Best Visualization Technical Blogs For DNN, PHP, ASP, .net

Dear All, If you need to read how many tables of SQL in your database has major record this script will help you. SELECT     t.NAME AS TableName,     s.Name AS SchemaName,     p.rows AS RowCounts,     ist.TABLE_CATALOG as tableCatalog,     SUM(a.total_pages) * 8 AS TotalSpaceKB,     SUM(a.used_pages) * 8 AS UsedSpaceKB,     (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM     sys.tables t INNER JOIN         sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN     sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN     sys.allocation_units a ON p.partition_id = a.container_id INNER JOIN   INFORMATION_SCHEMA.TABLES ist on ist.TABLE_NAME = t.name LEFT OUTER JOIN     sys.schemas s ON t.schema_id = s.schema_id WHERE     t.NAME NOT LIKE 'dt%'     AND t.is_ms_shi...

Dear All, If you want to get all SQL tables through query use the following command SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' order by table_name I hope it save your time Regards Rashid Bilgrami