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 vote249 views1 answer
Allow specific string in type
TypeScript
1 vote297 views1 answer
Styled components reset
TypeScript
29 votes280 views4 answers
File ng.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript
0 vote292 views1 answer
Ts in r
TypeScript
0 vote312 views1 answer
Cats internet cafe 18 hr
TypeScript
1 vote293 views1 answer
Cannot find name 'debounceTime'
TypeScript
0 vote274 views1 answer
Tslint shows double quotes error prettier
TypeScript
-2 votes280 views1 answer
C++ get digits of integer
TypeScript
0 vote268 views1 answer
How to round float to 2 decimal places
TypeScript
0 vote297 views1 answer
How to check whether url is responding or not in typescript
TypeScript