How do I add a column, with a default value, to an existing table in SQL Server 2008 or 2012? [duplicate]

Question

How do I add a column, with a default value, to an existing table in SQLServer 2008?

Pritesh Tayade · Accepted Answer · 2019-03-14 07:50:35Z

20

ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}

Add a column with a default value to an existing table in SQL Server

edited Mar 14, 2019 at 7:50

answered Jun 5, 2013 at 6:11

Pritesh Tayade

6404 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

peterm · Accepted Answer · 2013-06-05 06:10:40Z

9

Use ALTER TABLE. For example

ALTER TABLE Table1 
ADD  col2 INT DEFAULT 0;

SQLFiddle

answered Jun 5, 2013 at 6:10

peterm

93k16 gold badges157 silver badges162 bronze badges

2 Comments

TT. Over a year ago

As a general rule, it is best to name your constraints. If you don't it will get a random name, and they will differ between different databases (eg at different client installations). This will make scripting changes difficult in some cases (ie you will have to resort to workarounds).

peterm Over a year ago

@TT. Fair point. Agreed.

Collectives™ on Stack Overflow

How do I add a column, with a default value, to an existing table in SQL Server 2008 or 2012? [duplicate]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related