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 to run pl/sql statements in sql*plus?
What are the rules to be applied to nulls whilst doing comparisons?
What are the advantages of stored procedure?
What is the difference between Union and Union all. Which is faster.
What are the types of queries in sql?
what are null values? : Sql dba
What is the purpose of cursors in pl/sql?
Is it possible to sort a column using a column alias?
Is primary key clustered or nonclustered?
Can you rollback after commit?
What is dense_rank?
what is the syntax for using sql_variant_property? : Transact sql
Name some usages of database trigger?
How do I turn a list into a table?
Which one is faster ienumerable or iqueryable?