This article is tagged with:
Sql constraint query
and mysql
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
# 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