The syntax for adding a CHECK constraint with CREATE TABLE and ALTER TABLE is quite different.

Question

Quizplus · Accepted Answer

The syntax for adding a CHECK constraint in both CREATE TABLE and ALTER TABLE statements is similar, involving specifying the CHECK keyword followed by the condition in parentheses. The main difference is in the context of their use, where one is used during table creation and the other for modifying an existing table.

The Syntax for Adding a CHECK Constraint with CREATE TABLE