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

8 votes169 views4 answers
How to check open ports mac
TypeScript
0 vote125 views1 answer
Typescript type specific numbers
TypeScript
0 vote132 views1 answer
Create array of structs cpp
TypeScript
0 vote124 views2 answers
How to compare two entity objects in c# to update
TypeScript
4 votes124 views1 answer
Push elements of array to another array typescript
TypeScript
2 votes132 views1 answer
Jquery selector attribute value starts with
TypeScript
0 vote126 views2 answers
How to print more than 20 documents mongo shell
TypeScript
1 vote120 views1 answer
Difference between dictionary and sets in python
TypeScript
0 vote129 views1 answer
Typescript key as string
TypeScript
0 vote116 views1 answer
Loading assets in ionic react
TypeScript