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
Can you have more than one key in a database?
how many ways we can we find the current date using mysql? : Sql dba
What is sql architecture?
what is online transaction processing (oltp)? : Sql dba
What is rank () in sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Why do we use sql constraints?
How much does sql certification cost?
what is the difference between group by and order by in sql? : Sql dba
Why do we need sharding?
How do I view an execution plan in sql?
what is unique key constraint? : Sql dba
What is multiple columns?
Why use triggers in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?