What are the constraints in sql

This article is tagged with: What are the constraints in sql and mysql

what are the constraints in sql

NOT NULL # Ensures a column cannot have a NULL value
UNIQUE # Ensures all values in a column are unique
PRIMARY KEY # Identifies a record in a table, is NOT NULL & UNIQUE
FOREIGN KEY # References a unique record from another table
CHECK # Ensures all column values satisfy a condition
DEFAULT # Set a default value for a column if none is entered
INDEX # Quick way of retrieving records from database

sql constraint query

-- Note: this is for Oracle only
select *
from USER_CONSTRAINTS
where TABLE_NAME = '<your-table-name>';</your-table-name>

constraints in sql

RULES ABOUT THE COLUMNS IN TABLE
NOT NULL # Ensures a column cannot have a NULL value
UNIQUE # Ensures all values in a column are unique
PRIMARY KEY # Identifies a record in a table, is NOT NULL & UNIQUE
FOREIGN KEY # References a unique record from another table
CHECK # Ensures all column values satisfy a condition
DEFAULT # Set a default value for a column if none is entered
INDEX # Quick way of retrieving records from database

constraints in sql

# The most common constraints are
NOT NULL # Ensures a column cannot have a NULL value
UNIQUE # Ensures all values in a column are unique
PRIMARY KEY # Identifies a record in a table, is NOT NULL & UNIQUE
FOREIGN KEY # References a unique record from another table
CHECK # Ensures all column values satisfy a condition
DEFAULT # Set a default value for a column if none is entered
INDEX # Quick way of retrieving records from database

This article is tagged with: What are the constraints in sql and mysql