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 vote207 views1 answer
Detach process from its terminal
TypeScript
1 vote218 views1 answer
How to display server count on discord.js
TypeScript
0 vote197 views1 answer
What is use hsts in .net core
TypeScript
2 votes191 views1 answer
Typescript loop over map with value as array
TypeScript
0 vote240 views4 answers
Two form in rasa
TypeScript
1 vote224 views1 answer
Get coin prices node-binance
TypeScript
-3 votes280 views1 answer
Cool_beasts = {"octopuses":"tentacles", "dolphins":"fins", "rhinos":"horns"} for ___ in cool_beasts.items(): print("{} have {}".format(___))
TypeScript
1 vote186 views1 answer
Typescript type of component
TypeScript
1 vote194 views1 answer
How to pass children in react typescript
TypeScript
2 votes290 views1 answer
Error: failed to synchronize all databases (unable to lock database)
TypeScript