统计金蝶K3数据库表使用情况

--创建临时表
CREATE TABLE #tmp
(
    name VARCHAR(50),
    rows INT,
    reserved VARCHAR(50),
    data VARCHAR(50),
    index_size VARCHAR(50),
    unused VARCHAR(50)
);
--插入统计数据
INSERT INTO #tmp
(   name,
    rows,
    reserved,
    data,
    index_size,
    unused
)EXEC sp_MSforeachtable @command1 = "sp_spaceused '?'";

--查询关联数据
SELECT b.*,
    d.FDescription
FROM #tmp b
    LEFT JOIN dbo.t_TableDescription d
        ON FTableName = name
WHERE name <> 'tmp'
ORDER BY rows DESC;