/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 vote331 views1 answer
Add column alter table default value
SQL
3 votes317 views4 answers
Show columns from table
SQL
-1 vote333 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote348 views1 answer
Oracle select row max date
SQL
0 vote358 views1 answer
Mysql get hour from datetime
SQL
0 vote322 views1 answer
Mysql installer no packages found
SQL
0 vote301 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote373 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
5 votes348 views2 answers
Get number of columns sql
SQL
0 vote286 views1 answer
Sqlalchemy filter relationship
SQL