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 vote290 views1 answer
Array of objects create common key as a property and create array of objects
TypeScript
0 vote291 views1 answer
Cannot show Automatic Strong Passwords for app bundleID: com.williamyeung.gameofchats due to error: iCloud Keychain is disabled
TypeScript
1 vote256 views1 answer
Change textinputlayout color
TypeScript
0 vote277 views1 answer
W to check whether an image is a broken image or not in typescript angular
TypeScript
31 votes268 views4 answers
How to see all commits in git
TypeScript
27 votes309 views6 answers
Router.navigate angular
TypeScript
38 votes341 views3 answers
Cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
12 votes259 views3 answers
Intersection of lists in python
TypeScript
14 votes273 views5 answers
Enum as type typescript
TypeScript
28 votes292 views4 answers
Install typescript
TypeScript