WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
THAN U.
- 1 Answers
- 5612 Views
- Synergy, I also Faced
- E-Mail Answers
Answer / 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 |
What is the latest version of microsoft sql server?
How do I find information about the install locations for the various instances running on a computer?
Explain the creation and execution of a user-defined function in the sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Are semicolons required at the end of sql statements in sql server 2005?
What is tempdb database? : SQL Server Architecture
How to rebuild indexes with alter index ... Rebuild?
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
What is sql stored procedure?
What is difference between aggregate and analytic function?
Define outer join?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
