list all Tables

[Sphere]

Is there a sql statement to list all the tables in a db

 

[bigscouse]

This is a regular question to which the answer is &quot;It depends on which DBMS you are using&quot;. [sig]<p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>Top man[/sig]

 

[edge2000]

Assume its ms sql 6 or 7 then open a query window, select the database and type

select name from sysobjects where type = 'u' order by name

[sig]<p>Dave<br><a href=mailto:dab@completebs.com>dab@completebs.com</a><br><a href=

http://www.completebs.com>Complete

Bsuiness Systems</a><br>See website for more info but we can develop most things for most people.[/sig]

 

[nickdaniels]

select table_name from all_tables

for oracle [sig]<p> Nick<br><a href=mailto:ndaniels@ventura-uk.com>ndaniels@ventura-uk.com</a><br><a href= > </a><br>If it's Data Warehousing or related then I want to know - but post it to the forum![/sig]

 

[bigscouse]

in ingres

select *
from iitables
[sig]<p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>Top man[/sig]