- DECLARE @tableName nvarchar(100) --表名
- DECLARE @columnName nvarchar(100) --字段名
- SET @tableName = 'Bud_ContractConsTask'
- SET @columnName = 'TaskId'
- DECLARE @cname nvarchar(100)
- DECLARE _cursor CURSOR
- FOR
- SELECT 'ALTER TABLE ' + @tableName + ' DROP CONSTRAINT ' + CONSTRAINT_NAME
- FROM information_schema.CONSTRAINT_COLUMN_USAGE
- WHERE TABLE_NAME = @tableName AND COLUMN_NAME = @columnName
- OPEN _cursor
- FETCH NEXT FROM _cursor
- INTO @cname
- WHILE @@FETCH_STATUS = 0
- BEGIN
- EXEC(@cname) --执行删除语句
- FETCH NEXT FROM _cursor INTO @cname
- END
- CLOSE _cursor
- DEALLOCATE _cursor
- --该片段来自于http://www.codesnippet.cn/detail/100920135762.html
来源: http://www.codesnippet.cn/detail/100920135762.html