can you any body tell me the difference between candidate
key and primary key
- 4 Answers
- 7104 Views
- I also Faced
- E-Mail Answers
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
Where are stored procedures in sql server?
What is a deadlock and what is a live lock?
How do I determine how many instances of sql server are installed on a computer?
Explain the difference between cross join and full outer join?
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.
List types of tables in SQL Azure?
What is the full form of ddl?
How many databases Microsoft SQL server provides?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Explain timestamp datatype?
How can you check the version of sql server?
Write a SQL query to make a column as unique?
If user is owning any SQL Objects, can we drop that user
How you can get a list of all the table constraints in a database?
Show Practically Sql Server Views are updatable?
