Vote UpVote

InterBase Labs – Referential Integrity

Stephen Ball – InterBase Referential Integrity InterBase has a number of options for Referential Integrity that are powerful to use and simplify keeping data valid. This video covers (more reading from the InterBase DocWiki on the links here) Primary Key Unique Key Foreign Key Check Constraints Tip for adding Constraints. One very cool tip in the video is to use constraints to add in a unique key, this way you can drop it easily at runtime.  Remember, the field needs to be marketed NOT NULL to enable a primary or unique key. ALTER TABLE CUSTOMER ADD CONSTRAINT U_TEST UNIQUE (CUSTOMER_NAME); The above ...
Favorite? Off-Topic? Stephen Ball @ 2016-01-27 16:59


Visits: 827
Votes: 0
Favorites: 0
Off-Topic: 1

Visits by Source

User Actions

Users who voted for this posting

Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News


Please login or register to use this functionality.
(click on this box to dismiss)