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 vote363 views1 answer
How to find the index of property in array of object in typescript
TypeScript
-1 vote290 views1 answer
Two lists into one list of tules
TypeScript
2 votes322 views1 answer
Typescript inner class
TypeScript
-1 vote289 views2 answers
Cannot find name 'HttpHeaders'
TypeScript
0 vote295 views1 answer
Split list into sublists with linq
TypeScript
0 vote281 views1 answer
Whcih commands lets you an ip adress log
TypeScript
0 vote301 views1 answer
C# copy the elements of a list to another list
TypeScript
14 votes324 views2 answers
Upgrade to typescript in react js
TypeScript
0 vote282 views1 answer
Pandas value_counts sort descending
TypeScript
1 vote309 views1 answer
Remove &nbsp from string in typescript
TypeScript