Want to get list of all tables in a database

[Monika Jain]

 Posted by:  Monika Jain <Monika.Ja...@no-mx.forums.yourdomain.com.au> 

hi ,

i want to get a list of all the tables with table name.
is there any way we can list all the table names in a database


--
Monika Jain
------------------------------------------------------------------------
Monika Jain's Profile: http://www.dbtalk.net/m520
View this thread: http://www.dbtalk.net/t318753

[Björn Schlaack]

 Posted by:  ?Q?Bj=F6rn_Schlaack?= <bjoern....@materna.de> 

Re-Hi,
yes there is, try:
select name from systables where type='T' and system='N';

To get the tables' columns select from syscolumns.
Other system-tables are: sysviews (views), syspkconstraints (primary
keys), sysfkconstraints (foreign keys), systriggers (trigger).

Greets from germany

Björn Schlaack.