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 vote323 views1 answer
Correct this attempt to modify "product" or use "let" in its declaration. [+1 location]
TypeScript
0 vote295 views1 answer
Exits adn copy file in java
TypeScript
0 vote352 views1 answer
Angular Workspace
TypeScript
0 vote348 views1 answer
Meta tag utf-8 means kya hota hai
TypeScript
0 vote347 views1 answer
Display Popular Posts laravel
TypeScript
0 vote332 views1 answer
How to get label for points from a column in dataframe for scatter plot in python
TypeScript
1 vote364 views3 answers
Where do you get your test data
TypeScript
1 vote305 views1 answer
Iterate object ngfor
TypeScript
1 vote313 views1 answer
Typescript space between capital letters
TypeScript
0 vote324 views1 answer
Install brackets ubuntu 20.04
TypeScript