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

-1 vote179 views1 answer
Typescript dictionary contains key
TypeScript
0 vote186 views3 answers
Get weights of a layer keras
TypeScript
2 votes182 views1 answer
'mat-date-range-picker' is not a known element:
TypeScript
11 votes204 views2 answers
How to run resources in ionic
TypeScript
114 votes539 views3 answers
How to check whether file exists in python
TypeScript
0 vote184 views1 answer
If driver element exists python
TypeScript
0 vote139 views0 answer
TypeScript
0 vote182 views1 answer
Mat-sort not working in dynamically generated table
TypeScript
0 vote198 views1 answer
Do you use data structures in your current automation project
TypeScript
1 vote218 views2 answers
Check if element exists in array golang
TypeScript