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
What happens to a statement batch if there is a compilation error?
Can group functions be used in the order by clause in ms sql server?
Explain sub-query?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
How is sql used in sql server?
How to execute stored procedure and set temp table in sql server?
What are the types of dml?
How do I find the sql server instance name?
Tell me what is the difference between locking and multi-versioning?
How to list all schemas in a database?
What is named query? : sql server analysis services, ssas
What is a bit datatype?
What is data compression?
What is analysis service repository?
What is the use of commit?