Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread How do I get the list of tables
Mon, Oct 27 2008 4:23 PMPermanent Link

"Paul Coshott"
Hi All,

can anyone tell me the query I need to return the list of tables in a
database.

Thanks,
Paul

Mon, Oct 27 2008 6:52 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Paul,

> can anyone tell me the query I need to return the list of tables in a
> database.

SELECT * FROM Information.Tables
or
SELECT * FROM <DatabaseName>.Information.Tables

Depending on the context where you are executing the statement.

--
Fernando Dias
[Team Elevate]
Image