Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity and how is it achieved?
- 1 Answers
- 10943 Views
- Adea Solutions, I also Faced
- E-Mail Answers
Answer Posted / koteshwar rao .palleboina
when foreign key constraint is created on a column
referential integrity is achieved .
when foreign key constraint is created on a column,that
column reference other column in the different table or
even in the same table but the reference column must be
primary key or unique key.
when a new value is added in a column referenced with
foreign key ,then the foreign key relation checks whether
the new value matches with the reference column or not.
If value matches then they are allowed into the table
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What are some examples of schemas?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is usually the first word in a sql query?
How to add an address record into adventureworkslt?
What is the use of RDBMS?
Can you roll back the ddl statement in a trigger?
State a few properties of relational databases?
What is difference between sql and sql server?
What is the current pricing model of SQL Azure?
What is a unique index?
How many servers can we create in a single subscription?
Can you explain what is the use of custom fields in report?
How to perform key word search in tables?
Can a synonym name of a table be used instead of a table name in a select statement?
How to concatenate two character strings together?
