How to get table names from SQL server
SELECT *
FROM Master.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' order by TABLE_TYPE
SELECT *
FROM Master.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'VIEW' order by TABLE_TYPE
General
SELECT *
FROM WorkDB.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'VIEW' order by TABLE_TYPE
SELECT *
FROM Master.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' order by TABLE_TYPE
SELECT *
FROM Master.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'VIEW' order by TABLE_TYPE
General
SELECT *
FROM WorkDB.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'VIEW' order by TABLE_TYPE
