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 properties of the transaction?
Tell me what is sql profiler?
what authentication modes does sql server support? : Sql server database administration
what is nonclustered index
how can u get last observation in an unknown dataset ?
Do you know what are the differences between lost updates and uncommitted dependencies?
How to restore performance issues and how to check?
Write SQL queries on Self Join and Inner Join.
What are data driven subscriptions?
How do I open a .db file?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to rebuild indexes with alter index ... Rebuild?
How do I find the port number for sql server?
What is store procedure?
What is mean by candidate key?
