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 vote247 views1 answer
Font awesome reeact js example
TypeScript
5 votes245 views3 answers
Typescript convert date to string format dd/mm/yyyy
TypeScript
0 vote252 views2 answers
Window.print div
TypeScript
0 vote249 views2 answers
Reactive forms radio button
TypeScript
2 votes197 views1 answer
Mat-option change event
TypeScript
0 vote252 views1 answer
The marking menu shortcuts to context-sensitive commands and tools. Marking menu accessed for objects:
TypeScript
0 vote243 views1 answer
Linux Write a command to list all contents of files whose names start by a and end by z
TypeScript
37 votes298 views3 answers
Angular date pipe 24 hour format
TypeScript
0 vote227 views1 answer
HIGHER-ORDER FUNCTIONS with two parameters
TypeScript
-4 votes246 views1 answer
Whats a group of pandas called
TypeScript