Explain primary key and foreign key constraints?
Answer / Vikrant
Primary Key is a constraint used to ensure that each record in a table can be uniquely identified. It consists of one or more columns that contain unique values, and it enforces the uniqueness of those values.nnForeign Key is a constraint used to establish a relationship between two tables, where the foreign key in one table references the primary key of another table. It ensures referential integrity by preventing the deletion or modification of primary key values that have associated foreign key values.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I start sql server?
How to delete the duplicate rows from a table in SQL Server ??
What is meant by dirty read?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
What is row by row processing ?
Difference between drill down and drill through report.
What are rows and columns?
How to get the definition of a user defined function back?
Explain datetime2 data type in sal server 2008?
What are the differences between stored procedure and functions in SQL Server 2000?
25 Answers College School Exams Tests, HCL, Infosys, TCS,
Explain features and concepts of analysis services?
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)