SQL Server 2008 R2
Why
create table A
(
id int,
primary key nonclustered (id)
)
is correct and executed without errors?
But
create table A
(
id int,
primary key nonclustered id
)
is an error? giving
Incorrect syntax near ')'.
Collateral question:
Why
create table c(id int primary key clustered)
is executed
but
create table c(id int primary key nonclustered)
is an error? Sorry, both work.
Is it inconsistent syntax to be suggested for correction?