how many types of sql commands

How many types of sql commands

There are three types of SQL Commands in SQL.

  1. DDL
  2. DML
  3. DCL


Data Definition Language(DDL).DDL statements is use to create, modify, and remove database objects such as tables, indexes, and users.

  1. Create
  2. Alter
  3. Drop
  4. Truncate


Data Manipulation Language(DML).DML is used for selecting, inserting, deleting and updating data in a database.

  1. Select
  2. Insert
  3. Update
  4. Delete


Data Control Language(DCL).DCL is used to control access to data stored in a database

  1. Commit
  2. Rollback
  3. Savepoint
  4. Grant
  5. Revoke

Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: Sales: +91 8085506229