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 vote323 views3 answers
How to send tweets in c# WPF
TypeScript
1 vote372 views1 answer
Mongodb array size greater than
TypeScript
0 vote325 views1 answer
The softness of a spot lights edge is controlled by penumbra angle, value gives perfect hard edge:
TypeScript
2 votes303 views1 answer
Google Sheets How to Count business Days Between Two Dates
TypeScript
0 vote315 views1 answer
Nativescript display image from web
TypeScript
1 vote315 views1 answer
Set element disable in typescript
TypeScript
4 votes345 views3 answers
Cors npm typescript
TypeScript
0 vote309 views9 answers
Twitter analysis in R clean tweets
TypeScript
0 vote405 views1 answer
Typescript get class properties
TypeScript
1 vote314 views1 answer
Git writing objects slow
TypeScript