Lesson 12 Flashcards
1
Q
Constraints
A
Define rules specified for the data in a database table.
2
Q
DEFAULT Constraints
A
Used to provide a default value for a column.
3
Q
CHECK Column Constraint
A
Limits the value range that can be placed in a column.
4
Q
CHECK Table Constraints
A
Limits the values based on values in other columns in the row.
5
Q
NULL Constraint
A
A row can be added to the table without a value in the column.
6
Q
NOT NULL Constraint
A
Hey bro, cannot be added to the table without a value in the column.
7
Q
Primary Key (PK) Constraint
A
The unique column in a table.
8
Q
Index
A
Used in faster processing when query is executed.
