NONCLUSTERED PRIMARY KEY
Dixant Rai 4 years ago • updated 4 years ago • 5
Is it possible to create NONCLUSTERED PrimaryKey while still using the PK flag to identify them? I'm trying to achieve this in sql server.
Customer support service by UserEcho
Yes, this is possible - please see the screenshot with settings.
The generated SQL is:
Hello Mariusz, thanks for getting back to me. That is not what I meant. What I was trying to do would result in this DDL
Hello Mariusz, any update on this?
Sorry for delayed response.
It is currently not supported. I can suggest you dropping an index and creating it manually, e.g. in 'Additional SQL scripts -> After creating table' section.
Sorry for the inconvenience,
Thanks. I'll submit as a new feature request.