Constraints in database

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

Constraints in database

<center> tag

Similar codes

0 vote126 views3 answers
Passing Data between fragments in Android using Interface
TypeScript
4 votes79 views1 answer
Typescript update
TypeScript
0 vote241 views1 answer
Warning: format ‘%s’ expects argument of type ‘char *’, but argument 2 has type ‘int’
TypeScript
19 votes131 views4 answers
Material ui icon npm
TypeScript
0 vote125 views1 answer
Cannot find module '@tns-core-modules/application-settings' or its corresponding type declarations.
TypeScript
0 vote114 views1 answer
Testing techniques
TypeScript
0 vote181 views1 answer
You’re asked to read a file a line at a time. For each line, you have to split it into fields. Which of the following sets of pseudo class definitions is likely to be more orthogonal?
TypeScript
0 vote125 views1 answer
Multiple generic constraints c#
TypeScript
0 vote133 views1 answer
If statements equals same value python
TypeScript
2 votes121 views2 answers
Date format in typescript
TypeScript