Monday, July 9, 2012

SQL SERVER – 2005 List All Tables of Database

Anup Shah 5:47 PM

This is very simple and can be achieved using system table sys.tables.

USE YourDBName
GO 
SELECT *FROM sys.Tables
GO

This will return all the tables in the database which user have created.