SQL four statements, four integrity, five constraints

Four statements:

1. Data definition statements: ddl:create, ALTER, DROP, truncate (table structure)

2. Data manipulation statements: Dml:insert, delete, update, select

3. Data Control statement: DCL: Authorization: GRANT, REVOKE permission: Revoke

4. Error control statement: TCL: Start transaction: BEGIN TRANSACTION commit: Commit rollback: Rollback

Four major integrity:

1. Domain integrity, 2. Entity integrity, 3. Referential integrity, 4. Custom integrity

Five major constraints:

1. PRIMARY KEY constraint: Primary KEY (Pk_) 2. FOREIGN KEY constraint: foreign key (FK_) 3. Default constraint: Defaults key (DF_) 4. Unique constraint: Unique key (uq_) 5. Check Constraint: Checking key (Ck_ )

Reference: References

SQL four statements, four integrity, five constraints