can you any body tell me the difference between candidate
key and primary key
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 find the service pack installed? : sql server database administration
What are the types of ssrs?
What is a performance monitor?
How many levels of sp nesting are possible?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Create and insert into temp table in sql server?
What are the types of resultset?
Explain a differential backup?
plss anybody specify tha constrian management system in dbms
What is correlated subquery in sql server?
what is nonclustered index
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to modify the underlying query of an existing view?
What do you understand by mirroring and mention the advantages of the mirroring?
Explain different types of self contained sub query?