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 vote122 views1 answer
Pig Latin scripts to group your data
TypeScript
1 vote137 views1 answer
Google shets if
TypeScript
3 votes198 views1 answer
Typescript == vs ===
TypeScript
0 vote127 views6 answers
Python double check if wants to execute funtion
TypeScript
0 vote128 views1 answer
Flutter create widget for each element of list
TypeScript
0 vote125 views1 answer
Google sheets replace dot with comma
TypeScript
0 vote135 views1 answer
React inherit html input props
TypeScript
0 vote132 views1 answer
How to clear all products woocommerce keep category
TypeScript
0 vote119 views1 answer
Typescript dynamic dict
TypeScript
1 vote122 views1 answer
Move items from one log to another typescript
TypeScript