Why is a primary key important?
Answer / Geeta
A Primary Key is crucial in a database for several reasons: It uniquely identifies each record within a table, ensuring data integrity by preventing duplicate records. It serves as a foreign key in other tables, maintaining referential integrity. It can significantly improve query performance due to the ability to quickly find specific records. Lastly, it is an essential part of the relational model.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you sum a count in sql?
How do I upgrade sql?
write a query to display diference between two dates in sql server
How do we accept inputs from user during runtime?
Compare SQL and PL/SQL.
how to shut down the server with 'mysqladmin'? : Sql dba
What is schema in sql example?
Authentication mechanisms in Sql Server ?
What is the difference between delete and truncate statement in sql?
what is inline command?
What is clause?
How to trace the errors in pl/sql block code?
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)