How are the unique and primary key constraints different?
Answer / Aditya
The main difference between a unique constraint and a primary key constraint is that a table can have multiple unique constraints, while it can only have one primary key. Both constraints ensure that no duplicate values exist in the specified column(s), but the primary key provides additional features such as automatic enforcement of referential integrity.
| Is This Answer Correct ? | 0 Yes | 0 No |
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is the benefit of normalization?
Why people hate cursor?
What the class forname () does?
How to enable/disable indexes?
What purpose does the model database server?
What is the difference between a check constraint and a rule?
can any body tell me how to know the password of current user in sql server
How many triggers you can have on a table?
What is an indexing technique?
What is the difference between local table and global table
1 Answers CarrizalSoft Technologies, Polaris,
What is difference between primary key and foreign key?
Oracle (3253)
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)