sql server 删表外键约束报错

 创建两个表TblTestA，TblTestB，删掉TblTestA

			create table dbo.TblTestA(
			Id					bigint			primary key identity(1, 1),
			name			varchar(20)     unique,
		    )
	
			create table dbo.TblTestB(
			Id					bigint			primary key identity(1, 1),
			TestAId				bigint			not null foreign key references 
			Status				varchar(1),
	     	)

报错：it is referenced by a FOREIGN KEY constraint.

原因：其他表引用该表外键

解决：

1.查找该表被其他表引用的外键

  exec  sp_helpconstraint ‘表名’;