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 vote348 views1 answer
Oracle enable chain
SQL
0 vote375 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote365 views3 answers
Mysql parse int
SQL
11 votes376 views3 answers
How to get last row of table in sql
SQL
0 vote345 views1 answer
Get number of tables in database sql
SQL
1 vote356 views4 answers
Sequelize migration default value
SQL
1 vote406 views1 answer
Sql random sampling per group
SQL
0 vote366 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote351 views2 answers
Mysql dump structure only
SQL
1 vote343 views1 answer
Mysql history command
SQL