can you any body tell me the difference between candidate
key and primary key
Answer Posted / pooja
A primary key is one that uniquely identiifes each row.
and there is only one primary key per table.
candidate key:All that fields which can be selected as
primary key are called candidate keys.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is application role in sql server database security? : sql server security
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What are dml (data manipulation language) statements in ms sql server?
What is the use of sign function?
What is the Main Difference between ACCESS and SQL SERVER?
When we should use @@error?
How to create view in stored procedure sql server?
Does the unique constraint create an index?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is extended stored procedures?
What are the limitations/drawbacks or ssrs 2008 r2?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Can a trigger be created on a view?
Explain how does the report manager work in ssrs?
What are the rendering extensions of ssrs?