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

User · Answer

select   from  schema name  sys tables   This should work  Make sure you are on the server which consists of your   schema name

User · Answer

SQL Server 2005  2008  2012 or 2014   SELECT   FROM information schema tables WHERE TABLE TYPE  BASE TABLE  AND TABLE SCHEMA    dbo    For more details  How do I get list of all tables in a database using TSQL

User · Answer

Your should really use the INFORMATION SCHEMA views in your database   USE  lt your database name gt  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

User · Answer

SELECT   FROM sys tables t INNER JOIN sys objects o on o object id   t object id WHERE o is ms shipped   0

User · Answer

SELECT t name    FROM sys tables AS t   INNER JOIN sys schemas AS s   ON t  schema id    s  schema id    WHERE s name   N schema name

User · Answer

SELECT t1 name AS  Schema   t2 name AS  Table  FROM sys schemas t1 INNER JOIN sys tables t2 ON t2 schema id   t1 schema id ORDER BY t1 name t2 name

[sql] List names of all tables in a SQL Server 2012 schema

Examples related to sql

Examples related to sql-server