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;
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
--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;
You must be logged in to post a comment.
Big thanks to you for sharing such great information.
Thanks for appreciation.