How to get list of all tables in MS SQL Server?
SELECT * FROM information_schema.Tables where table_type = 'BASE TABLE'
From here.