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

Sql constarint

It creates a new constraint on an existing table, which is used to specify
rules for any data in the table.
Example: Adds a new PRIMARY KEY constraint named ‘user’ on columns
ID and SURNAME.
ALTER TABLE users
ADD CONSTRAINT user PRIMARY KEY (ID, SURNAME);

Similar codes

3 votes258 views2 answers
Conditional classes angular
TypeScript
0 vote239 views1 answer
Permalink of pending posts not working
TypeScript
3 votes246 views1 answer
Model has no objects member django
TypeScript
2 votes248 views2 answers
React native elements button with icon
TypeScript
1 vote265 views1 answer
Styled components reset
TypeScript
6 votes275 views4 answers
Property 'style' does not exist on type 'Element'.ts(2339)
TypeScript
0 vote255 views1 answer
Avoid hitting multiple same api hits angular
TypeScript
1 vote268 views1 answer
How do you generate test data
TypeScript
0 vote265 views1 answer
Loop localstorage
TypeScript
2 votes266 views1 answer
Adding headers to httpclient angular
TypeScript