Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the difference between candidate
key and primary key
- 4 Answers
- 8061 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
There can be more than one index in a table.
But only one field can be a Primary Key in a table.
All other index fields in a table are called candidate keys.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to add an address record into adventureworkslt?
How to get the query of a table in sql server?
Difference between uniqe index and uniqe constraint?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What structure can you implement for the database to speed up table reads?
Explain sql server authentication modes?
Do you know query execution plan?
How to test a dml trigger in ms sql server?
A trigger can reference objects outside the current database? State true or false.
Are semicolons required at the end of sql statements in sql server 2005?
What are sql dirty pages?
How to configure odbc dsn with different port numbers?
How to end a stored procedure properly in ms sql server?
what is a transaction and what are acid properties? : Sql server database administration
What are the approximate numeric data types?
