how to create a primary key with out creating an index?
Answer Posted / priyankur
Unique constraint will always create non-clustered index on
column. so creation of Unique constraint is not the
solution. Yes, only sequence can create unique column but
that is not necessarily Primary key unless you treat it
likewise.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do you control the max size of a heap table? : Sql dba
What are the key differences between SQL and PL SQL?
What is the difference between mdf and ndf files?
Does sql use python?
Which is better join or subquery?
Explain unique key in sql.
what is sql server agent? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What does desc stand for?
What are the qualities of 2nf?
What is the use of desc in sql?
Is primary key is clustered index?
what is the difference between clustered and non clustered index in sql? : Sql dba
Is sql a microsoft product?
how to shutdown mysql server? : Sql dba