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 vote264 views1 answer
Whats the extension of a markup language
TypeScript
2 votes248 views1 answer
C program to find sum of array elements using recursion
TypeScript
9 votes263 views3 answers
React typescript onclick type
TypeScript
0 vote277 views1 answer
Apply function to all elements with a class name
TypeScript
0 vote258 views1 answer
Run an applescript
TypeScript
2 votes269 views2 answers
Cannot use JSX unless the '--jsx' flag is provided.ts(17004)
TypeScript
1 vote274 views1 answer
Sass migrate division vue
TypeScript
0 vote272 views1 answer
Convert object to list of objects c#
TypeScript
0 vote294 views1 answer
Already included file name react tsconfig
TypeScript
0 vote275 views3 answers
Convert javascript function to typescript online
TypeScript