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!

Show tables in database

Status
Not open for further replies.
shawkz

shawkz

Programmer
Oct 25, 2005
84
GB
Hi is it possible to run an sql query which displays all table names in a database?

Kindest regards,

SHawkz
 
Sort by date Sort by votes
I do not know of any command that works across all platform, but most platforms that I have worked with (Oracle, Teradata, SQL Server) all have a system database which you can query to get the names of all tables.

What platform are you looking to accomplish this with?
 
Upvote 0 Downvote
Im just using asp, just want to list what tables there are against a database, simlar to list or fields against a table..

select top 1 * from company

regards,

SH
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
204
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
205
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
147
harfri
harfri
sqlguy1
  • Locked
  • Question
SQL Server 2008 database size
Replies
1
Views
118
genomon
genomon
jasonhuibers
  • Locked
  • Question
Count number of tables in database 1
Replies
2
Views
115
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top