list of tables in a db

[Todd]

Hi All
can some one please tell me the transact sql code that can list all tables
in a db.
thanks
Todd

[Anith Sen]

Re: list of tables in a db

There are many ways to do this. You can query the sysobjects system table or
the INFORMATION_SCH EMA views. Perhaps the easiest one would be :

EXEC sp_tables

--
- Anith
( Please reply to newsgroups only )