--统计数据库中表中行数
create table ##tableCount(
tableName varchar(500),
colCount int)
exec sp_msforeachtable 'insert into ##tableCount (tableName,colCount) select ''?'' tableName, count(*) colCount from ?'
select * from ##tableCount order by colCount
drop table ##tableCount
--显示所有数据库中表
exec sp_msforeachtable 'SELECT * FROM ?'
--清空数据库表
exec sp_msforeachtable 'DELETE FROM ?'
--删除表
exec sp_msforeachtable 'DROP TABLE ?'
create table ##tableCount(
tableName varchar(500),
colCount int)
exec sp_msforeachtable 'insert into ##tableCount (tableName,colCount) select ''?'' tableName, count(*) colCount from ?'
select * from ##tableCount order by colCount
drop table ##tableCount
--显示所有数据库中表
exec sp_msforeachtable 'SELECT * FROM ?'
--清空数据库表
exec sp_msforeachtable 'DELETE FROM ?'
--删除表
exec sp_msforeachtable 'DROP TABLE ?'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货