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 vote134 views2 answers
Typescript run on save
TypeScript
17 votes130 views3 answers
Typescript enum to string
TypeScript
0 vote149 views1 answer
Typescript default public or private
TypeScript
1 vote139 views1 answer
Json-server : File C:\Users\ROUSHAN SHARMA\AppData\Roaming\npm\json-server.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see
TypeScript
0 vote230 views1 answer
MInus points of exploration
TypeScript
0 vote141 views1 answer
How should a developer write unit tests for a private method in an apex class
TypeScript
0 vote161 views1 answer
Howt o make sure its a valid sudoku in python
TypeScript
0 vote143 views1 answer
The eval() function
TypeScript
0 vote128 views1 answer
Match a string that starts and ends with the same vowel
TypeScript
-1 vote134 views1 answer
Two lists into one list of tules
TypeScript