Adding a Check Condition

You can add a new CHECK condition to a table or to an individual column.

For example, in a library database, the date_returned column for a particular entry must be the same as, or later than the date_borrowed entry:
ALTER TABLE loan
ADD CHECK(date_returned >= date_borrowed)