Get all tables from database - SQL Server - Image

134. Get all tables from database – SQL Server

Get all tables from database – SQL Server

--Get all tables from database - SQL Server
SELECT schema_name(t.schema_id) as schema_name,
       t.name as table_name,
       t.create_date,
       t.modify_date
FROM sys.tables t
ORDER BY schema_name,
         table_name;

Sample Output:

Get all tables from database - SQL Server
Get all tables from database – SQL Server

2 comments

Leave a Reply