MSSQL清空所有表中数据

--1、取水所有表中约束，方便清空所有表数据而不受约束。NOCHECK 禁用约束，CHECK 启用约束

--SELECT 'alter table ['+OBJECT_SCHEMA_NAME(object_id)+'].['+OBJECT_NAME(object_id)+'] NOCHECK CONSTRAINT all' FROM sys.tables WHERE is_ms_shipped=0;

--2、删除所有表

--select 'delete ' + Name + ';' from sysobjects where xtype='U' order by name desc;

--3、将查询的结果复制执行

--4、--SELECT 'alter table ['+OBJECT_SCHEMA_NAME(object_id)+'].['+OBJECT_NAME(object_id)+'] CHECK CONSTRAINT all' FROM sys.tables WHERE is_ms_shipped=0;