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 derfloh 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
Joined
Oct 25, 2005
Messages
84
Location
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 Question
windows command in a sql script
Replies
1
Views
599
carp
carp
BobThornton
  • Locked
  • Question Question
Cross Join in an Insert Into
Replies
1
Views
578
carp
carp
harfri
  • Locked
  • Question Question
Insert into a new table
Replies
0
Views
438
harfri
harfri
sqlguy1
  • Locked
  • Question Question
SQL Server 2008 database size
Replies
1
Views
396
genomon
genomon
jasonhuibers
  • Locked
  • Question Question
Count number of tables in database
Replies
2
Views
310
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top