sql server 查看所有表记录数 表空间，记录数 行数

SELECT object_name (i.id) TableName,   
       rows as rows  
FROM sysindexes i   
INNER JOIN sysObjects o   
    ON (o.id = i.id AND o.xType = 'U ')   
WHERE indid < 2   
ORDER BY rows   desc

 

所有列名，列名所在表名

select name,OBJECT_NAME(id)from syscolumns 

 

 表空间

SELECT 
    OBJECT_SCHEMA_NAME(t.object_id) AS SchemaName,  -- 架构名称
    t.name AS TableName,                             -- 表名称
    p.rows AS RowCounts,                             -- 行数
    SUM(a.total_pages) * 8 / 1024 AS TotalSpaceMB,   -- 总占用空间(MB)
    SUM(a.used_pages) * 8 / 1024 AS UsedSpaceMB,     -- 已使用空间(MB)
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 / 1024 AS UnusedSpaceMB  -- 未使用空间(MB)
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
WHERE 
    t.is_ms_shipped = 0  -- 排除系统表
    AND i.object_id > 255  -- 排除系统对象
GROUP BY 
    t.object_id, t.name, p.rows
ORDER BY 
    TotalSpaceMB DESC;  -- 按总空间大小降序排列

 

所有存储过程

SELECT * FROM sysobjects where type='P' order by crdate desc