/SQL/Adding a default constraint to an existing column in sql

Adding a default constraint to an existing column in sql

--Altering an existing column to add a default constraint:
ALTER TABLE {TABLE NAME}
ADD CONSTRAINT {CONSTRAINT NAME}
DEFAULT {DEFAULT VALUE} FOR {EXISTING COLUMN NAME}

--Adding a new column, with default value, to an existing table:
ALTER TABLE {TABLE NAME}
ADD {COLUMN NAME} {DATA TYPE} {NULL | NOT NULL}
CONSTRAINT {CONSTRAINT NAME} DEFAULT {DEFAULT VALUE}

--Dropping a contraint:
ALTER TABLE {TABLE NAME}
DROP CONSTRAINT {CONSTRAINT NAME}

Similar codes

1 vote88 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote107 views1 answer
Oracle session statistics
SQL
0 vote123 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote63 views1 answer
Flask_sqlalchemy install
SQL
0 vote99 views2 answers
Sql query inner join 3 tables
SQL
0 vote94 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
19 votes103 views6 answers
Sql server drop table if exists
SQL
3 votes57 views1 answer
System.debug apex
SQL
1 vote100 views2 answers
Sql convert datetime to year month
SQL
1 vote126 views3 answers
Postgresql crete view
SQL