Ask
Login
0
22kviews
Explain Assertions and Triggers in detail.
written 8.9 years ago by gravatar for teamques10 teamques10 ★ 70k •   modified 3.8 years ago

Mumbai University > Computer Engineering > sem 4> database management system

Marks: 10M

Year: May16
database management systems
ADD COMMENT EDIT
1 Answer
0
93views
written 8.9 years ago by gravatar for teamques10 teamques10 ★ 70k

ASSERTION :

The CREATE ASSERTION statement names a new Constraint and defines the Constraint's deferral mode, initial constraint check time and its CHECK search condition. The required syntax for the CREATE ASSERTION statement is:

CREATE ASSERTION <Constraint name> 
CHECK (search condition) 
[ <constraint attributes> ]

CREATE ASSERTION defines a new …

Create a free account to keep reading this post.

and 5 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.