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

11 votes186 views3 answers
Python requests get proxy
TypeScript
9 votes152 views2 answers
Array contains typescript
TypeScript
0 vote133 views1 answer
Wifi disconnects frequently when downloading
TypeScript
0 vote181 views1 answer
Pandas value_counts sort descending
TypeScript
1 vote170 views1 answer
How to reset stats in diablo 2
TypeScript
6 votes152 views3 answers
Angular show element in component
TypeScript
1 vote186 views1 answer
No provider for ChildrenOutletContexts Angular
TypeScript
3 votes162 views2 answers
Lua print all elements table
TypeScript
25 votes216 views4 answers
Filter typescript
TypeScript
9 votes167 views2 answers
Warning: Can't perform a React state update on an unmounted component. This is a no-op, but it indicates a memory leak in your application. To fix, cancel all subscriptions and asynchronous tasks in a useEffect cleanup function.
TypeScript