/SQL/Sql script to remove default from column

Sql script to remove default from column

DECLARE @tableName VARCHAR(MAX) = '<MYTABLENAME>'
DECLARE @columnName VARCHAR(MAX) = '<MYCOLUMNAME>'
DECLARE @ConstraintName nvarchar(200)
SELECT @ConstraintName = Name 
FROM SYS.DEFAULT_CONSTRAINTS
WHERE PARENT_OBJECT_ID = OBJECT_ID(@tableName) 
AND PARENT_COLUMN_ID = (
    SELECT column_id FROM sys.columns
    WHERE NAME = @columnName AND object_id = OBJECT_ID(@tableName))
IF @ConstraintName IS NOT NULL
    EXEC('ALTER TABLE '+@tableName+' DROP CONSTRAINT ' + @ConstraintName)
    
-- Just replace <MYTABLENAME> and <MYCOLUMNNAME>

Source: stackoverflow.com

Similar codes

1 vote168 views3 answers
Union SQL
SQL
0 vote203 views1 answer
Insert output identity
SQL
0 vote187 views1 answer
Mysql cast null to string
SQL
0 vote200 views2 answers
Postgres having
SQL
1 vote174 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote171 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote192 views2 answers
Starts and end with vowel sql
SQL
0 vote172 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
2 votes175 views1 answer
Date conversion in mysql column
SQL
3 votes173 views1 answer
Sql case update
SQL