SQLServer笔记总结

1、SQL查看数据库中每张表的数据量和总数据量

SELECT a.name AS 表名, MAX(b.rows) AS 记录条数
FROM sys.sysobjects AS a INNER JOIN sys.sysindexes AS b ON a.id = b.id
WHERE (a.xtype = 'u')
GROUP BY a.name
ORDER BY 表名 DESC

exec sp_MSforeachtable N' if exists(select 1 from ?) print ''?''+''(Y)'' else print ''?''+''(N)'''

2、查询哪些表里有数据

select name from sysobjects where xtype='u'

select * from sys.tables
//查询数据库中所有的表名及行数

SELECT a.name, b.rows

FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id

WHERE (a.type = 'u') AND (b.indid IN (0, 1))

ORDER BY a.name,b.rows DESC