what is the command to list all tables in a database in SQL Server

Published by: Rinku (9/21/2008 10:22:47 AM)

I want to know what are all the tables present in a particular database. What is the SQL command to list all tables in a database in SQL Server. I want system tables to be filtered by the query and return only user created tables present in the database.Please Help.

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

Unable to Create Index for a Table in SQL Server Management Studio 2005 >>

<< How can i see the code (SQL Create Statement) for a stored procedure in SQL server