June 22nd, 2009 
joy 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% [?]
Related posts:
Posted in 
Tags: 
