Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Command to list all table names

Status
Not open for further replies.
jadoherty

jadoherty

IS-IT--Management
Feb 19, 2003
1
US
What command syntax can I use to query all the table names available in my Informix database?
 
Sort by date Sort by votes
A very simple sql statement will list all of the tables along with the owner in a database. This is it

INFO TABLES

Dodge20
If it ain't broke, don't fix it.
 
Upvote 0 Downvote
Another way:

select tabname from systables where tabid > 99 and tabtype = "T"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tuccero
  • Locked
  • Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
285
tuccero
tuccero
jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
200
jamescpp
jamescpp
evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
151
evgeniosc
evgeniosc
arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
207
arunkumar.ceg
arunkumar.ceg
kray4660
  • Locked
  • Question
Trying to do a count on logged in users
Replies
1
Views
217
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top