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

Sql constarint

It creates a new constraint on an existing table, which is used to specify
rules for any data in the table.
Example: Adds a new PRIMARY KEY constraint named ‘user’ on columns
ID and SURNAME.
ALTER TABLE users
ADD CONSTRAINT user PRIMARY KEY (ID, SURNAME);

Similar codes

0 vote98 views2 answers
Mat datepicker timezone not correct
TypeScript
0 vote107 views2 answers
Ng2003
TypeScript
0 vote107 views1 answer
Typescript api request header
TypeScript
0 vote156 views1 answer
Typescript checkbox event
TypeScript
68 votes275 views6 answers
Python activate virtual environment
TypeScript
1 vote135 views1 answer
Type script edeode url
TypeScript
0 vote171 views1 answer
Paint effects will render natively in maya software and maya hardware 2.0 render. Command will enable paint effects to render in Arnold or ay third-party render:
TypeScript
6 votes112 views2 answers
Ignore typescript error
TypeScript
0 vote118 views1 answer
Angular from date to date validation
TypeScript
0 vote114 views1 answer
Vue 3 bootstrap 5 tooltip
TypeScript