can some one please tell me the transact sql code that can list all tables
in a db.
thanks
ToddThere are many ways to do this. You can query the sysobjects system table or
the INFORMATION_SCHEMA views. Perhaps the easiest one would be :
EXEC sp_tables
--
- Anith
( Please reply to newsgroups only )
No comments:
Post a Comment