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

3 votes351 views2 answers
Array of objects how to check if property has duplicate
TypeScript
3 votes263 views4 answers
Html collection of elements to array
TypeScript
0 vote303 views1 answer
Typescript for vue
TypeScript
0 vote291 views1 answer
Dwayne johnson maui
TypeScript
6 votes282 views3 answers
Angular get url param
TypeScript
0 vote318 views1 answer
Requests module in vs code python
TypeScript
1 vote284 views1 answer
Dev/storage/logs" and its not buildable: Permission denied
TypeScript
1 vote265 views1 answer
Typescript use object keys as index
TypeScript
15 votes348 views5 answers
Typescript random int
TypeScript
0 vote287 views1 answer
Typescript split/partition array by condition
TypeScript