I have three filegroups in my database:
Default is TERTIARY. Now I want to create table on PRIMARY and it shows the following error
Incorrect syntax near the keyword 'primary'.
create table tb1 ( id int identity primary key nonclustered, somecolumn nvarchar(15) ) on PRIMARY;
When I change the default filegroup option to PRIMARY it lets to create tables on PRIMARY. Why does it show this error when my syntax is not wrong?
Thanks for your time.