|
|
Posted by Erland Sommarskog on 10/31/07 22:45
cong (franzcai80@gmail.com) writes:
> AUTHOR
> )REFERENCES ????(??)
> )
> ON PRIMARY
> )
> GO
>
> ROW 21:NEAR KEYWORD "PRIMARY" WRONG IN GRAMMA
As Roy said in an earlier post, put PRIMARY in square brackets:
ON [PRIMARY]
This is needed because PRIMARY here is just an identifier for the primary
filegroup. The clause could also be:
ON My_other_filegroup
As long as you don't use multiple filegroups, and it may take long before
you come around to that, you can skip the ON clause althogether, as it
just adds noise.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|