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 vote183 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote182 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
3 votes169 views2 answers
Sql not contains
SQL
0 vote175 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
1 vote177 views1 answer
Mysql decimal allow negative values?
SQL
0 vote138 views2 answers
Sql update from two different database
SQL
3 votes182 views1 answer
Stpop start psql server
SQL
-1 vote162 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
1 vote177 views1 answer
Sql server loop over query
SQL
0 vote164 views2 answers
Create sequence if not exists postgres
SQL