Discussion Forum | Board Infinity

SQL commands like DDL, DML, what commands do

Sql, Commands

  • DDL(Data Definition Language) : DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database. Ex : create, truncate
  • DML(Data Manipulation Language): The SQL commands that deals with the manipulation of data present in the database belong to DML or Data Manipulation Language and this includes most of the SQL statements.ex: insert, update, delete.