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 vote153 views1 answer
?In static pages, the contents are fluid and changeable (e.g., rotating banners).
TypeScript
0 vote150 views1 answer
React full calendar
TypeScript
0 vote325 views1 answer
Axes3D currently only supports the aspect argument 'auto'. You passed in 'equal'.
TypeScript
0 vote141 views1 answer
Typescript type array of interface
TypeScript
1 vote181 views1 answer
Npm uninstall typescript
TypeScript
0 vote145 views1 answer
On input inset - afetr 5 digits jquery
TypeScript
2 votes150 views1 answer
Session not created: This version of ChromeDriver only supports Chrome version 85
TypeScript
2 votes142 views1 answer
List of lists to single list python
TypeScript
0 vote164 views1 answer
Stripe create customer
TypeScript
0 vote148 views1 answer
Typescript type function callback in interface
TypeScript