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 gkittelson 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
Apr 12, 2006
5
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
windows command in a sql script
Replies
1
Views
222
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
215
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
158
harfri
harfri
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
153
mikrom
mikrom
Davest11
  • Locked
  • Question
Table or View does not exist
Replies
11
Views
273
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top