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

5 votes155 views5 answers
Angular 8 ngClass If
TypeScript
0 vote134 views1 answer
Local Variable in Jenkins
TypeScript
7 votes150 views2 answers
Remote events roblox
TypeScript
0 vote137 views2 answers
Sum the digits in c
TypeScript
1 vote164 views1 answer
Adoni db:seed
TypeScript
0 vote150 views1 answer
Python program to print the contents of a directory using os module
TypeScript
1 vote137 views1 answer
What is typescript in angular
TypeScript
0 vote140 views1 answer
How to check if there is any point which lies inside the circle
TypeScript
1 vote146 views1 answer
Google sheets return multiple columns with vlookup
TypeScript
0 vote99 views4 answers
Error: The method assertThat(T, Matcher<? super T>) in the type MatcherAssert is not applicable for the arguments (List<String>, Matcher<Iterable<Integer>>)
TypeScript