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 views2 answers
Oracle create chain rule
SQL
0 vote257 views2 answers
Install phoenix
SQL
19 votes192 views3 answers
How to change column type psql
SQL
1 vote227 views2 answers
Changes not showing on website server odoo
SQL
0 vote207 views1 answer
Hallo
SQL
0 vote270 views1 answer
DATEDIFF minute postgres
SQL
0 vote193 views3 answers
Remove folders from remote git
SQL
2 votes180 views1 answer
Postgresql change value in column
SQL
9 votes175 views3 answers
Show table columns mysql command line
SQL
0 vote351 views1 answer
Sql change a colum to unique
SQL