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 votes90 views1 answer
Typescript loop through string
TypeScript
38 votes191 views2 answers
Whats my ip
TypeScript
0 vote138 views1 answer
List of objects where linq
TypeScript
1 vote145 views1 answer
How to target all child elements css
TypeScript
0 vote149 views1 answer
Error TS2307: Cannot find module '@angular/cdk/bidi'.
TypeScript
0 vote161 views1 answer
Execution failed for task ':app:lint'. > Lint infrastructure error
TypeScript
0 vote156 views1 answer
Event
TypeScript
1 vote133 views1 answer
React protected routes typescript
TypeScript
8 votes137 views1 answer
React init ts
TypeScript
0 vote141 views1 answer
Vsc typescript auto build on save
TypeScript