Answer Posted / 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 |
Post New Answer View All Answers
How to remove duplicate rows from table except one?
Why and when do stored procedure recompile?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Is it possible to have clustered index on separate drive from original table location?
Can sql servers link to other servers like oracle?
What are the different SQL Server Versions you have worked on?
How can we solve concurrency problems?
What are the different subsets of sql?
Can one drop a column from a table?
What is acid mean in sql server?
what is spatial nonclustered index
do you know how to configure db2 side of the application? : Sql server database administration
Why use identity in sql server?
How do I create a trace in sql server?
Disadvantages of the indexes?
