Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity? What are the advantages of it?
- 4 Answers
- 31156 Views
- Descon, Digital Domain, I also Faced
- E-Mail Answers
Answer Posted / anand
Referential integrity
Referential integrity in a relational database is
consistency between coupled tables. Referential integrity
is usually enforced by the combination of a primary key or
candidate key (alternate key) and a foreign key. For
referential integrity to hold, any field in a table that is
declared a foreign key can contain only values from a
parent table's primary key or a candidate key. For
instance, deleting a record that contains a value referred
to by a foreign key in another table would break
referential integrity. A relational database management
system (RDBMS) enforces referential integrity, normally
either by deleting the foreign key rows as well to maintain
integrity, or by returning an error and not performing the
delete. Which method is used would be determined by the
referential integrity constraint, as defined in the data
dictionary.
| Is This Answer Correct ? | 44 Yes | 7 No |
Post New Answer View All Answers
what's new in sql server 2016?
Can sql server be linked with other servers like oracle?
How does using a separate hard drive for several database objects improves performance right away?
How you can get a list of all the table constraints in a database? : Sql server administration
How to connect to SQL Azure Database by using sqlcmd?
What is executereader?
What is sql stored procedure?
Explain in details security in SQL azure?
What is self contained scalar sub query?
How to generate create table script on an existing table in ms sql server?
Can you edit the .rdl code associated with a linked report?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What factors you will consider calculating the storage requirement for that view?
What is the difference between web edition and business edition?
What encryption security is available in sql azure?
