List of Table in a Database

Please how can I get list of tables in a database? Thanks.
Hi,

I would consider using the INFORMATION_SCHEMA Views:

SELECT * FROM
INFORMATION_SCHEMA.Tables

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de
|||Thanks. It works.