怎样得到1个数据库中每个表格的数据数目

USE pubs -- 可改成您的数据库名称SET NOCOUNTONDECLARE tables_cursor CURSORFORSELECT name FROM sysobjects WHERE type = 'U'

OPEN tables_cursorDECLARE @tablename varchar(30), @quote char(1)SELECT @quote = '"'

FETCH NEXT FROM tables_cursor INTO @tablenameWHILE (@@fetch_status <> -1)BEGINEXEC ("Select " + @quote+"Rows in " + @tablename + " = "+ @quote + ", count(*) from "+ @tablename)

FETCH NEXT FROM tables_cursor INTO @tablenameENDDEALLOCATE tables_cursorSET NOCOUNT OFF