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 vote199 views1 answer
Property 'breakpoints' does not exist on type 'DefaultTheme'.ts(2339)
TypeScript
0 vote174 views1 answer
Alternative for .include in typescript
TypeScript
0 vote179 views1 answer
Convert given seconds to space age on all planets of our solar system
TypeScript
0 vote181 views1 answer
Cannot find module 'ng2-pdf-viewer' or its corresponding type declarations
TypeScript
2 votes332 views1 answer
Carbohydrates and fats both
TypeScript
7 votes231 views2 answers
Arrow function in ts
TypeScript
0 vote179 views1 answer
Typescript array of object findindex
TypeScript
1 vote182 views2 answers
Show all posts from category
TypeScript
6 votes170 views2 answers
Typescript random boolean
TypeScript
-1 vote184 views1 answer
Is brackets a good code editor
TypeScript