What IS SQL ? - Types of SQL commands

SQL Commands

DDL (Data Definition Language)

1. Create

2. Drop

3. Alter

4. Truncate

DML (Data Manipulation Language)

1. Insert

2. Update

3. Delete

DCL (Data Control Language) control the users permissions on the database

1. Grant

2. Revoke

TCL (Transaction Control Language)

1. Commit

2. Rollback

3. Save Point

DQL (Data Query Language)