一次性刪除數據庫中的所有數據

增加外鍵約束示例

ALTER TABLE [dbo].[SY_USER_GROUP]  WITH CHECK ADD  CONSTRAINT [FK_SY_USER_GROUP_SY_USERGROUP_INFO] FOREIGN KEY([UG_GROUP_NO])
REFERENCES [dbo].[SY_USERGROUP_INFO] ([GI_GROUP_NO])
GO

一次生成刪除所有外鍵的SQL語句：

DECLARE @SQL VARCHAR(MAX)
SET @SQL = ''

select  @SQL = @SQL + 'ALTER TABLE ' + e_name + ' DROP CONSTRAINT ' + o_name + ' '
from (select distinct e.name as e_name, o.name as o_name 
from  sys.foreign_key_columns f join sys.objects o on f.constraint_object_id=o.object_id 
LEFT JOIN  sys.objects e on f.parent_object_id=e.object_id 
) as t

--EXEC(@SQL)

SELECT @SQL

關閉所有觸發器：

EXEC sp_MSforeachtable @whereand = 'and o.name not like "BAS%" and o.name not like "BS%" '
, @command1 = 'ALTER TABLE ? DISABLE TRIGGER ALL'

啟用所有觸發器：

EXEC sp_MSforeachtable @whereand = 'and o.name not like "BAS%" and o.name not like "BS%" '
, @command1 = 'ALTER TABLE ? ENABLE TRIGGER ALL'

刪除所有指定的表中的數據、

  EXEC sp_MSforeachtable @whereand = 'and O.name NOT  like "BAS%" and O.name NOT  like "BS%"'
       , @command1 =' truncate table    ? '