Flash cards
Review the key moves
1/3
Core idea
What is the main idea behind SQL Constraints?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Order
Put the learning moves in the order that makes the concept easiest to apply.
Constraints are used to prevent insertion of invalid data in a table, and ensures the accuracy and reliability of the data in the table.
SQL constraints are rules for data in a table.
SQL Constraint Types
SQL constraints are rules for data in a table.
Constraints are used to prevent insertion of invalid data in a table, and ensures the accuracy and reliability of the data in the table. If there is any violation between the constraint and the data action, the action is aborted.
Constraints can be specified in two ways:
- When a table is created (through the CREATE TABLE statement)
- After a table is created (through the ALTER TABLE statement)
SQL Constraint Types
The following constraints are commonly used in SQL:
- NOT NULL - Ensures that a column cannot have a NULL value
- UNIQUE - Ensures that all values in a column are unique
- PRIMARY KEY - Uniquely identifies each row in a table (a combination of a NOT NULL and UNIQUE )
- FOREIGN KEY - Establishes a link between data in two tables, and prevents action that will destroy the link between them
- CHECK - Ensures that the values in a column satisfies a specific condition
- DEFAULT - Sets a default value for a column if no value is specified
- CREATE INDEX - Creates indexes on columns to retrieve data from the database faster