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 vote221 views1 answer
Using es6 set in typescript
TypeScript
-1 vote238 views3 answers
Lodash merge array of objects without duplicates
TypeScript
1 vote230 views1 answer
Typescript json.parse
TypeScript
1 vote258 views1 answer
Vue router mode history typescript
TypeScript
12 votes217 views3 answers
Intersection of lists in python
TypeScript
2 votes270 views1 answer
How to delete all elements from hashmap in java except one
TypeScript
0 vote235 views1 answer
Typeorm data array from relation
TypeScript
0 vote240 views1 answer
HideMyAss VPN review: Tests, FAQ, pros and consthinkmobiles.com › products HideMyAss vpn location test. Test
TypeScript
1 vote242 views3 answers
How to make all elements in array int python
TypeScript
7 votes230 views4 answers
Angular set query params
TypeScript