查询大表数据

select o.name,i.rows
from sysobjects o,sysindexes i
where o.id=i.id and o.xtype='U' and i.indid<2 and i.rows>3000
order by i.rows DESC

 

use [database_name]
delete from [table_name]