How to get a list of all tables in MS SQL Server?
select TABLE_NAME from information_schema.tables where Table_Type = 'BASE TABLE'
Posted on March 12, 2008 by Viktar Karpach
select TABLE_NAME from information_schema.tables where Table_Type = 'BASE TABLE'