How I get the list of tables in a database. I'm using sql server 2000.
Thanksquery the sysobjects system table.
I don't recall off the top of my head which criteria signifies 'table', but a quick look in the table should sort that out rapidly ;-)|||Or better yet, make use of the INFORMATION_SCHEMA fields, the TABLES view in particular.
For more information, check out this recent post:view post 449573, or Books Online (as always).
Terri|||Thanks a lot!!!
I got the answer
No comments:
Post a Comment