SQL commands like DDL, DML, what commands do

Data Science, AI and ML
,
#1

Sql, Commands

#2
  • 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.
#3

These all are the SQL commands:

  • Ddl: Stands for (data definition language), It deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database.Example- Create, Drop Alter, Truncate, Alter.
  • Dml: Stands for( data manipulation language), deals with the manipulation of data present in the database. Example- Select,Insert,Update, Delete.
  • Dcl: Stands for (data control language), deals with the rights, permissions and other controls of the database system. Example- Grant, Revoke.