SQL脚本：清空并重建数据库表 Leyi20180801

--删除外键约束表
IF EXISTS(SELECT * FROM sys.Tables WHERE name='外键约束20180801')
DROP TABLE 外键约束20180801
GO
--创建外键约束表
CREATE TABLE [dbo].[外键约束20180801](
[id] [int] IDENTITY(1,1) NOT NULL,
[外键约束名] [nvarchar](500) NOT NULL,
[子表名] [nvarchar](500) NOT NULL,
[外键列名] [nvarchar](500) NOT NULL,
[父表名] [nvarchar](500) NOT NULL,
[主键列名] [nvarchar](500) NOT NULL
) ON [PRIMARY]
GO

--将外键详情插入到新表
insert into [外键约束20180801](外键约束名,子表名,外键列名,父表名,主键列名)
select fk.name 外键约束名 , ftable.name 子表名, cn.name 外键列名, rtable.name 父表名, cnn.name 主键列名
from sysforeignkeys 
join sysobjects fk 
on sysforeignkeys.constid = fk.id 
join sysobjects ftable 
on sysforeignkeys.fkeyid = ftable.id 
join sysobjects rtable 
on sysforeignkeys.rkeyid = rtable.id 
join syscolumns cn 
on sysforeignkeys.fkeyid = cn.id and sysforeignkeys.fkey = cn.colid
join syscolumns cnn 
on sysforeignkeys.rkeyid = cnn.id and sysforeignkeys.rkey = cnn.colid
GO