我有表prsl,它有自动生成的约束名称。我想搜索数据库里保存这些名字的地方。ALTER TABLE dbo.PRSL DROP CONSTRAINT PK__PRSL__1C1D47DC0BF1ACC7
实际上,我想动态地删除这些约束。例如
SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[PRSL]')删除表上的所有约束。
删除约束'when found‘
发布于 2015-01-21 21:35:27
如果您愿意显示给定表的所有约束
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS
where TABLE_NAME = 'YOUR TABLE NAME'如果要删除给定表的所有约束,请使用以下命令:
DECLARE @database nvarchar(50)
DECLARE @table nvarchar(50)
set @database = 'dotnetnuke'
set @table = 'tabs'
DECLARE @sql nvarchar(255)
WHILE EXISTS(select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where constraint_catalog = @database and table_name = @table)
BEGIN
select @sql = 'ALTER TABLE ' + @table + ' DROP CONSTRAINT ' + CONSTRAINT_NAME
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS
where constraint_catalog = @database and
table_name = @table
exec sp_executesql @sql
END它对me...Hope有效,它有助于..。
https://stackoverflow.com/questions/28067723
复制相似问题