Incorrect syntax near 'for' SQL Server

Question

I want to add a new Column to an existing Table that has already Data in it. The Column should be NOT NULL. Because of that i want to set a Default Value. But when i do it throws the following exception: "Incorrect syntax near 'for'"

ALTER TABLE Semester ADD SIDNew uniqueidentifier NOT NULL 
CONSTRAINT DF_SIDNew DEFAULT '00000000-0000-0000-0000-000000000000' FOR SIDNew

I already had a look at How to set a default value for an existing column and Incorrect syntax near the keyword 'FOR' but none of them helped me.

Andrew Carmichael · Accepted Answer · 2017-02-24 14:16:31Z

4

Simply lose the part FOR SIDNew. You are adding a new column with a default constraint. You are not adding a new default constraint to an existing column.

edited Feb 24, 2017 at 14:16

Andrew Carmichael

3,1231 gold badge24 silver badges22 bronze badges

answered Feb 24, 2017 at 14:02

Mithrandir

25.5k6 gold badges53 silver badges67 bronze badges

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

Comments

Andrew Carmichael · Accepted Answer · 2017-02-24 14:27:13Z

3

The FOR keyword is only required if you're adding default values to Azure SQL Data Warehouse or Parallel Data Warehouse. If you're using normal relational SQL Server (on-premise or Azure) then you can just write it without the FOR

ALTER TABLE Semester ADD SIDNew uniqueidentifier NOT NULL 
CONSTRAINT DF_SIDNew DEFAULT '00000000-0000-0000-0000-000000000000';

https://msdn.microsoft.com/en-gb/library/ms190273.aspx

edited Feb 24, 2017 at 14:27

answered Feb 24, 2017 at 14:05

Andrew Carmichael

3,1231 gold badge24 silver badges22 bronze badges

Collectives™ on Stack Overflow

Incorrect syntax near 'for' SQL Server

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related