DML : The statement that works with data in database is called Data manipulation language.
Example:
- SELECT - Get rows from tables
- UPDATE - Update the rows of tables
- DELETE - Remove rows from tables
- INSERT - Add new rows to tables
DDL: The Statement that works with object in database is called Data Definition language.
Example:
- Create Table Statement
- Create Database Statement
- Create Index Statement
- Drop Statement
- Alter Statement
- Drop table Statemet
- Drop Database Statement