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 vote160 views1 answer
Fetch syntax in javascript
TypeScript
0 vote162 views1 answer
Requirements check failed for jdk 8 (
TypeScript
0 vote176 views6 answers
How to find nuber of tweets per day using python
TypeScript
0 vote172 views1 answer
How to add id in array javascript
TypeScript
189 votes182 views27 answers
Reduce javascript
TypeScript
0 vote164 views1 answer
How to remove the white space between two plots in r
TypeScript
-1 vote174 views1 answer
Java list of objects example
TypeScript
0 vote177 views1 answer
Typescript array to string
TypeScript
0 vote232 views1 answer
Typescript triple slash
TypeScript
20 votes195 views10 answers
Nodemon
TypeScript