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
- 8395 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
How would we use distinct statement? What is its use?
What are sql server procedures?
How many types of subqueries are there in sql server?
What are statistics?
What is a unique index?
How do I view a stored procedure in sql server?
Can truncate be rolled back?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are cursors in ms sql server?
How can you append an identity column to a temporary table?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is self contained sub query?
What are the transaction properties?
Explain difference between control flow and data flow?
What is logshipping and its purpose?
