WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
THAN U.
- 1 Answers
- 5598 Views
- Synergy, I also Faced
- E-Mail Answers
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 will happen if a column containing char type data is changed to the nchar data type?
what is datawarehouse?
What is a ddl statement?
How to copy data from one table to another table?
How to turn on the mssql api module in php?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Define clusters?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to use wildcard characters in like operations in ms sql server?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is the importance of a recovery model?
What is the report model project?
What is index, cluster index and nonclustered index?
What is a subquery in a select query statement in ms sql server?
Can we use where and having clause together?
