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!

system table that holds all tables

Status
Not open for further replies.
tls9923

tls9923

Technical User
Joined
Aug 7, 2002
Messages
155
Location
US
I know there is a system table that has all the names of tables withen a database I just cannot remember what it is.

Thanks

TLS
 
Sort by date Sort by votes
I believe that would be Master..SysOjects

Thanks

J. Kusch
 
Upvote 0 Downvote
or (maybe) better
information_schema.tables


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

baran121
  • Locked
  • Question Question
take a database from system databse place
Replies
2
Views
814
iambob
iambob
lavadan
  • Locked
  • Question Question
current max value of all int columns
Replies
1
Views
385
fredericofonseca
fredericofonseca
mrmovie
  • Locked
  • Question Question
ODBC connection, or other from Linus system using AD account details
Replies
2
Views
442
mrmovie
mrmovie
SamBones
  • Locked
  • Question Question
Report Queries That Have Been Submitted
Replies
3
Views
389
kjv1611
kjv1611
dgillz
  • Locked
  • Question Question
How to create login that has access to only certain tables in a database
Replies
4
Views
490
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top