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 is indexing done in search engines?
What is the most restrictive isolation level? : Transact sql
Explain the steps needed to create the scheduled job?
How can I delete duplicate rows?
What is execution plan in sql?
What is the clause we need to add in function body to return variable?
What are conditional predicates?
What are tables and fields?
What is serial sql?
How to write html code in pl sql?
What is the difference between delete and truncate commands?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Does user triggers have entry for trigger with compilation errors?
how to load data files into tables with 'mysqlimport'? : Sql dba
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure