/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

9 votes265 views3 answers
Oracle undo usage by session
SQL
1 vote255 views1 answer
Sql try catch
SQL
0 vote286 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
1 vote295 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote226 views1 answer
Jooq finding lastest value in table
SQL
3 votes272 views1 answer
Pl sql escape &
SQL
0 vote267 views1 answer
Formatting code with SQL Developer
SQL
0 vote259 views1 answer
Postgresql regular expression special characters
SQL
0 vote275 views2 answers
Sqlite unique
SQL
7 votes246 views2 answers
Create index mysql
SQL