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 vote218 views1 answer
Length of object in typescript
TypeScript
0 vote237 views1 answer
Can check constraints reference other tables
TypeScript
1 vote224 views2 answers
Clipping input data to the valid range for imshow with RGB data ([0..1] for floats or [0..255] for integers)
TypeScript
0 vote239 views2 answers
Remove upsell products woocommerce
TypeScript
0 vote223 views1 answer
Test events where not received
TypeScript
1 vote209 views1 answer
Git writing objects slow
TypeScript
1 vote247 views1 answer
CLIENT MISSING INTENTS discord
TypeScript
7 votes233 views2 answers
Remote events roblox
TypeScript
0 vote218 views1 answer
Nestjs get request header in guard
TypeScript
2 votes231 views2 answers
Typeorm find orderby
TypeScript