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

0 vote156 views1 answer
Typescript react switch case component
TypeScript
1 vote176 views1 answer
Ts object field from variable
TypeScript
0 vote165 views1 answer
Cannot find name 'modalRef'
TypeScript
1 vote169 views1 answer
Remove all children of node in typescript
TypeScript
1 vote155 views1 answer
Ion input ngmodel not working ionic 6
TypeScript
1 vote126 views1 answer
Take commits from main and move to a new branch
TypeScript
2 votes198 views2 answers
Constraints in database
TypeScript
0 vote167 views1 answer
Onblur vs valuechange
TypeScript
0 vote157 views1 answer
HIGHER-ORDER FUNCTIONS with two parameters
TypeScript
1 vote177 views1 answer
Headphone disconnects in ubuntu
TypeScript