Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
THAN U.
- 1 Answers
- 6338 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 options are there to delete rows on the publisher and not on the subscriber? : sql server replication
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
What does the not null constraint do?
Difference between uniqe index and uniqe constraint?
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
What are the purpose of Normalisation?
Give a example to search fr a string in all stored procedure in sql server.
After removing a table from database, what other related objects have to be dropped explicitly?
Define full outer join in sql server joins?
Explain sub-query?
What is an entity-relationship diagram (erd)?
How to create a trigger for insert only?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
