Get all the tables name from a database –TIP #3

We can get all the table’s name from a database using following simple syntax

GO
SELECT * FROM sys.objects WHERE type=’U’ AND Name <> ‘sysdiagrams’
GO

or we can use following command
GO
SELECT * FROM sys.tables
GO
The result of above statement is same

Or we can use one more command which is as follow

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME <>’sysdiagrams’
Go

For more information you can visit http://msdn.microsoft.com/en-us/library/ms190324.aspx

Enjoy !!!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

code