SQL glossary: Freelancer level

3 SQL terms at the Freelancer level, each with a short definition and a link to its full page.

Updated

Study these as flash cards

Deferrable Constraint
A constraint whose checking may be postponed until transaction completion.
Initially Deferred
A constraint mode starting each transaction with checking postponed until commit.
Initially Immediate
A constraint mode starting each transaction with checking performed after each statement.

Every SQL term, by level