Drop constraint in ms sql

DECLARE @sql NVARCHAR(MAX)
WHILE 1=1
BEGIN
    SELECT TOP 1 @sql = N'alter table tbloffers drop constraint ['+dc.NAME+N']'
    from sys.default_constraints dc
    JOIN sys.columns c
        ON c.default_object_id = dc.object_id
    WHERE 
        dc.parent_object_id = OBJECT_ID('tbloffers')
    AND c.name = N'checkin'
    IF @@ROWCOUNT = 0 BREAK
    EXEC (@sql)
END

Source: stackoverflow.com

Similar codes

0 vote236 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote226 views1 answer
Sort by last two number sql
SQL
0 vote290 views1 answer
Get last inserted primary key
SQL
8 votes215 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
7 votes277 views2 answers
Phpmyadmin change password
SQL
0 vote209 views1 answer
Sql last 3 rows
SQL
0 vote207 views1 answer
Insert or update sql firebird
SQL
1 vote199 views1 answer
Mysql copy table1 to table2
SQL
50 votes308 views6 answers
Sql count duplicate rows
SQL
0 vote205 views1 answer
Sql change primary key to composite key
SQL