This isn’t working in SQL Server 2008:

ALTER TABLE Employee ALTER COLUMN CityBorn SET DEFAULT 'SANDNES'

The error is:

Incorrect syntax near the keyword ‘SET’.

What am I doing wrong?

14 Answers
14

Leave a Reply

Your email address will not be published. Required fields are marked *