SQL Server Constraints Flashcards
1
Q
NOT NULL
A
Ensures that a column cannot have a NULL or empty value
2
Q
UNIQUE
A
Ensures that all values in a column are different
3
Q
PRIMARY KEY
A
Uniquely identifies each row in a table
4
Q
FOREIGN KEY
A
Used to create the link to another table
5
Q
CHECK
A
Ensures that all values in a column satisfy a specific condition
6
Q
DEFAULT
A
Sets a default value for a column when no value is specified; for example, set a default for state if most customers are from FL
7
Q
INDEX
A
Used to create and retrieve data from the database very quickly
8
Q
CONSTRAINT
A
Is a rule in the database
