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

1 vote99 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote96 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote101 views1 answer
Sql server datetime to string
SQL
0 vote111 views1 answer
Every Derived yable must have its own alias
SQL
6 votes95 views5 answers
Get current date sql
SQL
23 votes102 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote111 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
1 vote97 views1 answer
Alphabetical order mysql
SQL
0 vote94 views2 answers
Insert into
SQL
0 vote94 views2 answers
How do I install microsoft SQL on my Mac?
SQL