Monday, July 9, 2012

SQL SERVER – 2005 List All Tables of Database


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.

No comments:

Post a Comment