WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
THAN U.
Answer Posted / sakthi
Primary key:
It is an unique identifier, it wont allow null value, in a
table there will be only one column as primary key.
Composite key:
It same as Primary key but combination of more that one
column.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Why can there be only one clustered index and not more than one?
Can you edit the .rdl code associated with a linked report?
What is the use of commit?
Can a function call a stored procedure in sql server?
What is dynamic cursor in SQL SERVER?
What do you understand by SQL*Net?
Why should one not prefix user stored procedures with ‘sp_’?
Tell me something about security and sql azure?
What is default constraint in ms sql server?
What is command parameter in ssrs?
What do you know about normalization and de- normalization?
Difference between Sql server reporting services and Crystal reports?
How can I create a report based on a query? : sql server management studio
Is it possible in sql table to have more than one foreign key?
How to create a view using data from another view?