We a can get the list of all tables of a database in different ways : -
1.
SELECT * FROM sys.TABLES
2.
SELECT * FROM sysobjects WHERE TYPE='U'
3.
SELECT * FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
Popularity: 2% [?]
How to Get The List Of All Tables in a Database – Sql Server 2005
June 22nd, 2009 
joy 
Posted in 
Tags: 
