Constraints in database

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

Constraints in database

<center> tag

Similar codes

0 vote245 views1 answer
Mysql workbench an apparmor policy prevents this sender
TypeScript
0 vote197 views2 answers
Localstorage.getitem angular
TypeScript
2 votes246 views1 answer
Merge properties of object typescript
TypeScript
0 vote244 views1 answer
Find unique elements in pandas and their connection with other column
TypeScript
0 vote355 views1 answer
Print unordered_set c++
TypeScript
5 votes260 views2 answers
Init empty object typescript
TypeScript
0 vote261 views1 answer
Adding two lists using lambda function
TypeScript
0 vote244 views1 answer
Too many requests jquery laravel
TypeScript
1 vote245 views1 answer
Adonisjs hooks
TypeScript
0 vote248 views1 answer
Typescript how to define class properties to empty
TypeScript