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
Why do we use stored procedures in sql server?
What are the encryption mechanisms in sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How except clause is differs from not in clause?
What are the advantages to use stored procedures?
What is dbcc updateusage?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What are a database and a data warehouse?
How to backup SQL Server Reporting Services ?
What are the restraints imposed on the table design by a merge replication?
How to delete all rows with truncate table statement in ms sql server?
What will happen if a column containing char type data is changed to the nchar data type?
How can sql server instances be hidden?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Do you know what are the steps to process a single select statement?