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 vote194 views1 answer
Serenity conditional formatting grid row
TypeScript
0 vote199 views1 answer
C# linq get list of objects based on another list
TypeScript
-1 vote204 views2 answers
Passing props with typescript object
TypeScript
0 vote214 views1 answer
Google sheets format number as duration formula
TypeScript
0 vote194 views1 answer
Running tests in r
TypeScript
53 votes510 views4 answers
Digits of pi
TypeScript
1 vote202 views1 answer
++i vs i++
TypeScript
0 vote201 views1 answer
Angular cancel http request
TypeScript
0 vote201 views1 answer
Error on indexing the object in ts
TypeScript
0 vote194 views1 answer
Total infosys employees
TypeScript