Answer Posted / 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 |
Post New Answer View All Answers
What are the requirements on sql server network connections?
What is the difference between clustered and non-clustered indexes in ms sql server?
What are the types of user defined functions in sql server?
What happens when the SQL Azure database reaches Max Size?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
List the different types of joins?
What is mean by candidate key?
What's new in sql management studio for sql server? : sql server management studio
can a table be moved to different filegroup? : Sql server administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are the types of lock supported by ?
What is difference between foreign key and unique key?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How to test a dml trigger in ms sql server?
How do you create a data source?
