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 vote318 views1 answer
Can we nested try statements in java
TypeScript
7 votes353 views1 answer
Sort list of objects python
TypeScript
7 votes319 views5 answers
Reactnative typescript
TypeScript
1 vote312 views1 answer
Vue save page elements to pdf
TypeScript
2 votes364 views1 answer
Typescript enum to array
TypeScript
14 votes311 views3 answers
Generic arrow function typescript
TypeScript
1 vote311 views1 answer
Count objects in selenium java
TypeScript
0 vote267 views1 answer
Typescript dynamic array key
TypeScript
0 vote284 views1 answer
Install vsts client version 14.102.0
TypeScript
20 votes303 views5 answers
Flatten a list of lists python
TypeScript