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

2 votes206 views2 answers
Capacitor icon and splash
TypeScript
0 vote194 views1 answer
Tolowercase typescript
TypeScript
0 vote187 views1 answer
Mergensherts meaning
TypeScript
0 vote203 views1 answer
Ts enum string' can't be used to index type
TypeScript
3 votes196 views1 answer
Can't bind to 'formcontrol' since it isn't a known property of 'input'.
TypeScript
0 vote220 views1 answer
How to find the index of property in array of object in typescript
TypeScript
0 vote198 views1 answer
'mat-icon' is not a known element:
TypeScript
0 vote193 views1 answer
Typescript foreach object ts(7053)
TypeScript
0 vote204 views1 answer
Ts remove first 0 number from string
TypeScript
0 vote197 views1 answer
Can ts object be strongly typed?
TypeScript