sql script to remove default from column

Solutions on MaxInterview for sql script to remove default from column by the best coders in the world

Search
showing results for - "sql script to remove default from column"
Mariana
10 Mar 2018
1DECLARE @tableName VARCHAR(MAX) = '<MYTABLENAME>'
2DECLARE @columnName VARCHAR(MAX) = '<MYCOLUMNAME>'
3DECLARE @ConstraintName nvarchar(200)
4SELECT @ConstraintName = Name 
5FROM SYS.DEFAULT_CONSTRAINTS
6WHERE PARENT_OBJECT_ID = OBJECT_ID(@tableName) 
7AND PARENT_COLUMN_ID = (
8    SELECT column_id FROM sys.columns
9    WHERE NAME = @columnName AND object_id = OBJECT_ID(@tableName))
10IF @ConstraintName IS NOT NULL
11    EXEC('ALTER TABLE '+@tableName+' DROP CONSTRAINT ' + @ConstraintName)
12    
13-- Just replace <MYTABLENAME> and <MYCOLUMNNAME>
source
similar questions
sql drop columnadd column table sql default valuedelete from table where length sqlspace not removing from column in sqldrop column if exists sql serveroracle drop default valuesql comand for removing data from tablesql server create table column default value constraint namesql remove column from tablesql delete where x or y or zmssql remove columndefault number in sqlsql server drop constraint default valuesql drop defaultset default column value sqltsql delete data where column 3dsql delete klauselsql delete columnsql delete all values in a columnsql select without column namehow to check default value of column in sql serversql default
queries leading to this page
alter table delete column sql server default valuedelete default constraint column sql serverremove column default value sqldrop column with default value in sqldrop a column to a sql table with default value in sql serversql remove default value columnsql remove default objectalter table drop column with default value in sqlremove default from column sqlremove default value from column sql serverremove default sql server columnsql remove default objectsql remove default valuesql remove sql defaultremove default clause sqlt sql remove default value from columnremove default sql serversql server drop column with default constrainton delete set default sql examplehow to remove column name in sql with default valuesql delete default sql remove column with a default valuedefault for delete sqlsql remove defaultdrop column default sql serveralter table remove column with default value sql serverhow to remove column in sql with default valuesql script to remove default from columnsql server on delete defaultssql script to remove default from column