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

7 votes261 views3 answers
How to call a function that other scripts can access in unity
TypeScript
6 votes266 views4 answers
Angular get url params
TypeScript
0 vote267 views4 answers
Excel check if value exists in range
TypeScript
0 vote318 views1 answer
Cannot find module 'dotenv' or its corresponding type declarations
TypeScript
0 vote266 views1 answer
Targe id that starts with
TypeScript
0 vote238 views1 answer
What is the importance of testng xml file
TypeScript
-1 vote251 views1 answer
Angular input change event datatype typescript
TypeScript
0 vote254 views3 answers
SocketException: An attempt was made to access a socket in a way forbidden by its access permissions. in core 6.0
TypeScript
0 vote276 views1 answer
Wordpress number of posts by user
TypeScript
1 vote269 views1 answer
Ion-datetime open programmatically
TypeScript