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 vote340 views1 answer
Drop specific row postgresql
SQL
3 votes320 views1 answer
Oracle rollback
SQL
0 vote338 views1 answer
Como hacer una consulta en sql
SQL
9 votes319 views2 answers
Mysql change value
SQL
0 vote326 views1 answer
Describe in sqlite3
SQL
3 votes326 views2 answers
Oracle apex view logs
SQL
2 votes316 views1 answer
Postgresql add entry to table
SQL
22 votes431 views4 answers
Mysql format date
SQL
0 vote329 views1 answer
Oracle sql drop table
SQL
0 vote335 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL