Change nullability add primary key in one statement

Question

Is there are more terse way of writing (SQL server 2008)

alter table newclaims alter column id int not null go alter table newclaims add primary key(id)

the table is very large and this will have to make two passes over it and I'd like to know if I can change the nullability and add the primary key all in one statement.

Andomar · Accepted Answer · 2013-04-29 17:54:23Z

1

The documentation for alter table suggests that you cannot both alter a column and add a constraint.

ALTER TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name { ALTER COLUMN column_name { ... } | ADD { ... } [ ,...n ]

answered Apr 29, 2013 at 17:54

Andomar

239k55 gold badges387 silver badges412 bronze badges

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

1 Comment

wootscootinboogie Over a year ago

completely unrelated but by you posting that I a light bulb went on for me understanding how to read that documentation. You posting that little snippet there really helped me out on something completely unrelated

Collectives™ on Stack Overflow

Change nullability add primary key in one statement

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related