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

1 vote372 views1 answer
Powershell script remove directory recursive
TypeScript
0 vote319 views1 answer
Convert c# class to typescript
TypeScript
0 vote335 views2 answers
When should you stop testing
TypeScript
0 vote337 views1 answer
Cannot find module '@azure/msal-angular' or its corresponding type declarations.ts(2307)
TypeScript
0 vote344 views1 answer
Update object in array in ngxrx store in angular
TypeScript
10 votes328 views4 answers
Python add elements of two lists together
TypeScript
14 votes346 views2 answers
How to remove elements from object in typescript
TypeScript
0 vote363 views1 answer
C# ienumerable wrap to know when its compltee
TypeScript
1 vote352 views1 answer
What does a test have
TypeScript
1 vote332 views1 answer
Ts object field from variable
TypeScript