Querying all table names select name from sysobjects where xtype= ' u '
SELECT name, object_id, principal_id, schema_id, parent_object_id, type, Type_desc, Create_date, Modify_date, Is_ms_sh ipped, is_published,
Is_schema_published, lob_data_space_id, filestream_data_space_id, max_column_id_used, Lock_on_bulk_load, Uses_ansi_ Nulls, is_replicated,
Has_replication_filter, is_merge_published, is_sync_tran_subscribed, Has_unchecked_assembly_data, Text_in_row_ Limit
Large_value_types_out_of_row
From Sys.tables
Querying all table names and rows in the database
SELECT A.name, B.rows
From Sys.sysobjects as a INNER JOIN
Sys.sysindexes as B on a.id = b.ID
WHERE (B.indid in (0, 1)) and (A.type = ' u ')
ORDER by A.name, B.rows DESC
Query all indication and space consumption \ line number
SELECT object_name (ID) as TableName, 8 * reserved/1024 as reserved, RTRIM (8 * dpages) + ' KB ' as used, 8 * (Reserved -Dpages)/1024x768 as unused,
8 * dpages/1024-rows/1024 * minlen/1024 as free
From sys.sysindexes
WHERE (indid = 1)
ORDER by tablename, reserved DESC
SQL Server queries all table names and rows and space usage for data