List names of all tables in a SQL Server 2012 schema

Question

I have a schema in SQL Server 2012.

Is there a command that I can run in SQL to get the names of all the tables in that schema that were populated by user?

I know a similar query for MySQL SHOW TABLES; but this does not work with SQL Server.

Answer 1

Your should really use the INFORMATION_SCHEMA views in your database:

USE <your_database_name> GO SELECT * FROM INFORMATION_SCHEMA.TABLES 

You can then filter that by table schema and/or table type, e.g.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'