如何得到一个数据库中每个表格的数据数目

如何得到一个数据库中每个表格的数据数目

>

参考下列方法可以获得每个表格的数据数目。

USE pubs -- 可改成您的数据库名称

SET NOCOUNT

ONDECLARE tables_cursor CURSOR

FOR

SELECT name FROM sysobjects WHERE type = @#U@#

OPEN tables_cursor

DECLARE @tablename varchar(30), @quote char(1)

SELECT @quote = @#"@#

FETCH NEXT FROM tables_cursor INTO @tablename

WHILE (@@fetch_status <> -1)

BEGIN

EXEC ("Select " + @quote+"Rows in " + @tablename + " = "+ @quote + ", count(*) from "+ @tablename)

FETCH NEXT FROM tables_cursor INTO @tablename

END

DEALLOCATE tables_cursor

SET NOCOUNT OFF