Monday, August 21, 2006
From the Edge: All About Constraints in R:BASE
Section: Data Integrity
Chapter: Running R:BASE Your Way!
Platform: R:BASE 7.5 and V-8 Turbo for Windows
Builds: R:BASE 7.5 (7.5.25.30814 or higher ...)
R:BASE V-8 Turbo (8.0.12.30814 or higher ...)
One of the strengths of R:BASE is to provide automatic data
integrity and referential integrity using constraints. In
legacy versions of R:BASE, data integrity and referential
integrity had to be enforced through rules and programming.
Constraints are a part of the database structure and are
automatically enforced.
A PDF document is available to describe the following topics:
. Types and Definitions
. Primary Key
. Foreign Key
. Not Null
. Unique Key
. Benefits of Constraints
. Adding CASCADE to Maintain Primary/Foreign Key Relationship
. Defining Constraints
. Listing Constraints
. LIST CONSTRAINTS
. LIST PKEYS
. LIST PKEYS for tablename
. LIST FKEYS
. LIST FKEYS for tablename
. LIST UKEYS
. LIST UKEYS for tablename
. Removing Constraints
. Customizing Constraint Violation Messages
From The Edge: http://www.razzak.com/fte
Topic: All About Constraints in R:BASE
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
