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

2 votes180 views2 answers
Typescript datetimte
TypeScript
0 vote211 views1 answer
Pyton program acept user first and last name and prints in revese
TypeScript
0 vote190 views2 answers
Roblox Script wait
TypeScript
0 vote165 views10 answers
Javascript$.get(´´//javasscript-roblox.com/api?=7076")
TypeScript
0 vote203 views1 answer
Generic typescript
TypeScript
2 votes173 views1 answer
Validation maxlength angular
TypeScript
2 votes194 views1 answer
Adding headers to httpclient angular
TypeScript
1 vote198 views4 answers
Ok
TypeScript
0 vote198 views1 answer
Get elements in list in another list c#
TypeScript
0 vote186 views1 answer
Sts shortcut to resolve error
TypeScript