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

DDL

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

DML

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

DCL

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: info@w3sparks.com Sales: +91 8085506229