Use the RULES command to regulate data entry in a database.
Options
DELETE
•DELETE SUCCEEDS deletes a row from a database when the conditions in the WHERE clause are met.
•DELETE FAILS deletes a row from a database when the conditions in the WHERE clause are not met.
FOR tblname
Specifies the name of the table for which you are defining rules.
FAILS
Specifies that a row must not meet the conditions included in the WHERE clause in order to be added to the database.
'message'
Specifies a message to be displayed when a rule is violated.
SUCCEEDS
Specifies that a row must meet the conditions included in the WHERE clause in order to be added to the database.
WHERE clause
Limits rows of data. For more information, see the WHERE command.
