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 vote297 views1 answer
Function which calculates the number of tweets that were posted per day.
TypeScript
0 vote318 views1 answer
Array of objects create common key as a property and create array of objects
TypeScript
3 votes291 views4 answers
How to run typescript file
TypeScript
0 vote267 views1 answer
Debian install typescript
TypeScript
22 votes297 views5 answers
How to combine 2 lists in python
TypeScript
0 vote325 views1 answer
Upload keystore file to secrets github actions
TypeScript
8 votes297 views5 answers
Documents ready deprecated
TypeScript
1 vote248 views1 answer
Pip install from requirements txt
TypeScript
0 vote310 views1 answer
Python multiple named imports on one line
TypeScript
0 vote279 views1 answer
Laravel unique working with softdeletes
TypeScript