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

1 vote188 views1 answer
Python check if attribute exists in class
TypeScript
0 vote206 views1 answer
Python create dir when not exsit
TypeScript
0 vote221 views1 answer
Get typescript props of component
TypeScript
1 vote201 views1 answer
Typescript space between capital letters
TypeScript
0 vote199 views1 answer
Nestjs Monogdb Handel Catch Error
TypeScript
0 vote198 views1 answer
Ionic scroll to item programmatically
TypeScript
2 votes196 views1 answer
Multer s3
TypeScript
6 votes188 views1 answer
Comments pycharm
TypeScript
-1 vote207 views1 answer
What is lexicographically smallest string
TypeScript
1 vote190 views2 answers
Open vsc with admin rights linux
TypeScript