Can Check constraint be used for self referential integrity ?

6 like 0 dislike

Hello,

Can Check constraint be used for self referential integrity ?How?

Please give me your feedback

asked 1 year ago by mafia (1,300 points)

1 Answer

1 like 0 dislike

Best answer

Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.

answered 1 year ago by rad_joshep (19,390 points)

Related questions

5 like 0 dislike

1 answer

What is Referential Integrity ?

asked 1 year ago by rad_joshep (19,390 points)

5 like 0 dislike

1 answer

Where the integrity constraints are stored in Data Dictionary ?

asked 1 year ago by rad_joshep (19,390 points)

7 like 0 dislike

1 answer

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

asked 1 year ago by daneim (127,080 points)

4 like 0 dislike

1 answer

How will you a activate or deactivate integrity constraints ?

asked 1 year ago by daneim (127,080 points)

3 like 0 dislike

1 answer

Can a view be updated/inserted/deleted?

asked 1 year ago by daneim (127,080 points)