Declaring Assertions

• CREATE ASSERTION <name> CHECK (<condition>)

CREATE ASSERTION RichPres CHECK

(NOT EXISTS

(SELECT *

FROM Studio, MovieExec

WHERE presC# = cert#

AND netWorth < 10000000))

Checked whenever any change occurs to the database.

Previous slide

Next slide

Back to first slide

View graphic version