What are primary keys and foreign keys?
Answers were Sorted based on User's Feedback
Answer / nevual
Primary keys are the unique identifiers for each row. They
must contain unique values and cannot be null. Due to their
importance in relational databases, Primary keys are the
most fundamental of all keys and constraints. A table can
have only one Primary key.
Foreign keys are both a method of ensuring data integrity
and a manifestation of the relationship between tables.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sudarsan
Primary key is a unique id for each table. This prevents
duplication of records. Each table can have a single
primary key. They can be refrenced by any tables as a
foreign key.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / jai prakash chauhan
Primary keys are by default clustered index.
Is This Answer Correct ? | 3 Yes | 2 No |
What is Left Outer Join?
What are the different types of subquery?
what is a live lock? : Sql server database administration
How do you find the number of rows in a table?
What is triggers and its types?
Is sql server implemented as a service or an application? : Sql server database administration
What is the difference between a function and a stored procedure?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
How can we check the sql server version?
What is the difference between OLEDB and ODBC
How to edit table in sql server 2017?
Please differentiate between a local and a global temporary table?