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

3 votes204 views2 answers
Oracle synonym
SQL
0 vote198 views1 answer
How many columns can be used for creating index?
SQL
0 vote192 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
2 votes205 views3 answers
How to pass password mysql command line
SQL
16 votes216 views5 answers
Select last row in sql
SQL
31 votes212 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote206 views1 answer
Mysql url data type
SQL
1 vote211 views2 answers
How to search date in sql query
SQL
0 vote195 views1 answer
Renommer schema sql
SQL
0 vote191 views1 answer
Oracle enable chain
SQL