Saturday, August 04, 2012 11:27 AM
When I create a primary key Index on table which already has store column index , It display syntax error
Although I create the primary key from SSMS , Design a table , Set Primary key , Then Save ,
I did not write any code and the error message is syntax error !!
Saturday, August 04, 2012 11:53 AM
Monday, August 06, 2012 2:07 AM
It seems to work ok in both designer and TSQL in CU2 (11.0.2325). Which version version are you using. Can you post a sample table create script that is failing?
If you try it in TSQL you may get a better error message.
alter table mytable add constraint PK_Col1 primary key clustered (Col1);