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 !!!
