SELECT
a.name,
a.id,
b.pagecnt*
(
SELECT
@@maxpagesize) table_size_kb
FROM
(
(
SELECT
*
FROM
sysobjects
WHERE
type='U'
AND uid =
(
SELECT
uid
FROM
sysusers
WHERE
name ='dbo')
AND name IN('ZLZ_ZIZENG') )a
LEFT JOIN
(
SELECT
*
FROM
systabstats
WHERE
pagecnt>0 )b
ON
sybase 查询表大小
最新推荐文章于 2021-05-03 15:22:02 发布