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
- 8392 Views
- I also Faced
- E-Mail Answers
Answer Posted / vani
A candidate is a one that can identify each row in a table
uniquely.If a table has more than one candidate key , one
of them will become primary key.
The potential primary key is a candidate key.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Write the queries for commands like Create Table, Delete table, Drop Table etc.
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How you can get a list of all the table constraints in a database? : Sql server administration
What is precedence constraint?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Can a database be shrunk to 0 bytes, if not, why?
Explain atomicity?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Is foreign key a primary key?
What is indexing in sql server with example?
What are the events recorded in a transaction log?
What is the query and subquery?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What are sub reports and how to create them?
How does stuff differ from the replace function?
