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!

Return table names in database.

Status
Not open for further replies.
mkingrey

mkingrey

Programmer
Joined
Apr 12, 2006
Messages
5
Location
US
I am trying to return the name for each table in my database using SQL. Is this possible?

Thanks
 
Sort by date Sort by votes
Usually ... but exactly how depends on which RDBMS you are using. I suggest that you post in the forum specific to your RDBMS.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]
 
Upvote 0 Downvote
the standard way is to query the INFORMATION_SCHEMA views, but it would still be better to ask again in the forum for your specific database

r937.com | rudy.ca
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question Question
windows command in a sql script
Replies
1
Views
602
carp
carp
BobThornton
  • Locked
  • Question Question
Cross Join in an Insert Into
Replies
1
Views
580
carp
carp
harfri
  • Locked
  • Question Question
Insert into a new table
Replies
0
Views
439
harfri
harfri
mikrom
  • Locked
  • Question Question
from a table with symmetric relation select every pair only once
Replies
0
Views
439
mikrom
mikrom
Davest11
  • Locked
  • Question Question
Table or View does not exist
Replies
11
Views
873
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top