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 vote120 views2 answers
How to find geopoints radius in mongoose
TypeScript
87 votes179 views6 answers
Typescript random number
TypeScript
0 vote109 views1 answer
Keyboard shortcuts spotify
TypeScript
0 vote188 views1 answer
Warning: format ‘%s’ expects argument of type ‘char *’, but argument 2 has type ‘int’
TypeScript
1 vote106 views1 answer
Typescript array of react elements
TypeScript
0 vote125 views1 answer
Odata filter equal
TypeScript
0 vote133 views4 answers
C++ sort vector of objects by property
TypeScript
5 votes116 views4 answers
How to take float input upto 2 decimal points in python
TypeScript
2 votes67 views1 answer
Make props optional react typescript
TypeScript
0 vote112 views1 answer
2 decimal points react native
TypeScript