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 vote155 views1 answer
Ngx-numeral
TypeScript
1 vote124 views1 answer
What is test management review
TypeScript
2 votes165 views2 answers
Change material ui appbar color
TypeScript
2 votes172 views1 answer
Typescript create guid
TypeScript
1 vote157 views2 answers
Adjust distance of subplots in python
TypeScript
0 vote173 views1 answer
How to set date axes limits in matplotlib plot
TypeScript
0 vote185 views1 answer
S'entrainer pour tests techniques developpeurs web
TypeScript
2 votes161 views1 answer
Usedisclosure
TypeScript
0 vote163 views1 answer
The Android Gradle plugin supports only Kotlin Gradle plugin version 1.3.40 and higher. The following dependencies do not satisfy the required version: project ':video_compress' -> org.jetbrains.kotlin:kotlin-gradle-plugin:1.3.31
TypeScript
0 vote168 views1 answer
Nested slots in vue
TypeScript