-
Contributing Member
Issue
If we create a primary key then automatically it creates an unique clusterd index, but for any table there is only one clusterd index is allowed, If i want to create an uniue clusterd index on other column can i do it? If how?
-
Re: Issue
please find a related discussion here.
-
Junior Member
Re: Issue
Hi,
As you mentioned above it is not possible to create more than one clustered index or unique clustered index.
So,
For creating new one drop the existing one.
-
Contributing Member
Re: Issue
Hi mobin,
It is possible to create more than one clustred index on a table.
so You answer is wrong...
-
Junior Member
Re: Issue
table can have only one clustered index, and it can have more than one non-clustered index
-
Junior Member
Re: Issue
one table can have one clustered index and 249 non clustered index.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules