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 vote389 views1 answer
Fputs c++
TypeScript
1 vote388 views2 answers
Ffmpeg batch convert ts to mp4 files in a folder
TypeScript
0 vote327 views1 answer
$clients = User::query()->where("type","client" )
TypeScript
0 vote334 views1 answer
Ts in r
TypeScript
0 vote350 views1 answer
List of elements in watir
TypeScript
0 vote388 views1 answer
Close mat dialog programmatically
TypeScript
0 vote321 views1 answer
Class-validator not working nest-typescript-starter
TypeScript
1 vote362 views2 answers
Typescript global variable
TypeScript
2 votes323 views2 answers
How to get the elements that missing in other tables sql
TypeScript
0 vote314 views1 answer
Mac mini late 2010
TypeScript