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

10 votes316 views2 answers
Python get first n elements of list
TypeScript
-2 votes298 views3 answers
Typescript count array condition
TypeScript
0 vote321 views1 answer
How to pass node arguments in nextjs
TypeScript
2 votes311 views1 answer
Add elements to middle of array using splice
TypeScript
0 vote894 views1 answer
Nestjs fail on unknown properties
TypeScript
0 vote312 views1 answer
Google sheets sumif
TypeScript
1 vote313 views1 answer
Create docker secrets bash script
TypeScript
2 votes291 views1 answer
How long does it take to learn typescript
TypeScript
0 vote295 views1 answer
Typescript import variable from another file
TypeScript
0 vote331 views2 answers
Iframe redirects to another page
TypeScript