want to get list of all tables in a database

comp.databases.gupta (1995-2015)
Monika Jain

want to get list of all tables in a database

Post by Monika Jain » 12 Jul 2006, 16:00

 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

want to get list of all tables in a database

Post by Björn Schlaack » 13 Jul 2006, 09:36

 Posted by:  =?ISO-8859-1?Q?Bj=F6rn_Schlaack?= <bjoern....@materna.de> 

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

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

Greets from germany

Björn Schlaack.

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 1 guest