---
title: "What are the 5 types of SQL?"  
description: "What are the 5 types of SQL?"  
author: "Utpal Vishwas"  
published: 2023-08-27  
updated: 2023-08-28  
canonical: https://www.mindstick.com/forum/159677/what-are-the-5-types-of-sql  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql"]  
reading_time: 1 minute  

---

# What are the 5 types of SQL?

What are the 5 types of [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)?

## Replies

### Reply by Aryan Kumar

There are 5 types of SQL commands, but let me introduce you to the 4 basic ones:

**Data Definition Language (DDL):** This type of command is used to create, alter, and drop database objects, such as tables, views, and stored procedures.

**Data Manipulation Language (DML):** This type of command is used to insert, update, delete, and select data from tables.

**Data Query Language (DQL):** This type of command is used to retrieve data from tables.

**Transaction Control Language (TCL):** This type of command is used to manage transactions, such as starting, committing, and rolling back transactions.

The fifth type of SQL command, **Data Control Language (DCL)**, is not as commonly used as the other four. It is used to manage user access to databases, such as granting and revoking permissions.


---

Original Source: https://www.mindstick.com/forum/159677/what-are-the-5-types-of-sql

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.