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 Rhinorhino 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
Joined
Feb 19, 2003
Messages
1
Location
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 Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
771
tuccero
tuccero
jamescpp
  • Locked
  • Question Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
542
jamescpp
jamescpp
evgeniosc
  • Locked
  • Question Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
452
evgeniosc
evgeniosc
arunkumar.ceg
  • Locked
  • Question Question
How to call informix 4gl from script
Replies
0
Views
521
arunkumar.ceg
arunkumar.ceg
kray4660
  • Locked
  • Question Question
Trying to do a count on logged in users
Replies
1
Views
556
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top