What is referential integrity and how is it achieved?
Answer / 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 |
What is a database in ms sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to create a simple user defined function in ms sql server?
How to use wildcard characters in like operations in ms sql server?
Define cursor locking
What are a scheduled jobs?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
What is use of dbcc commands?
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
What is difference between views and stored procedures?
What are the five characteristics of good data?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?