api: YAML JSON TOON Database
version: 1.0.0
format: json
dataset:
  id: 18
  slug: sql-query-types
  title: SQL Query Types Reference
  description: "Categories of SQL statements for data definition, manipulation, and control."
  summary: "The SQL statement categories: DDL for schema, DML for changing data, DCL for permissions, TCL for transactions and DQL for queries, each with its full name, the statements it contains and its purpose."
  use_when[2]: You need to classify a SQL statement or explain the categories to a newcomer.,You are setting permissions by statement category.
  caveats[2]: Some sources fold SELECT into DML and omit DQL as a separate category.,Which statements are transactional differs by database; DDL is auto-committed in some systems and transactional in others.
  related[3]: sql-join-types,acid-vs-base,database-comparison
  category: Database Types
  category_slug: database-types
  tags: "sql,database,query,reference"
  view_count: 0
  created_at: 1777673262
  updated_at: 1777673262
  entry_count: 5
  fields[4]{section,field,type,example}:
    query_types,category,string,DDL
    query_types,full_name,string,Data Definition Language
    query_types,statements,string,"CREATE, ALTER, DROP, TRUNCATE"
    query_types,purpose,string,Define and modify database schema
data:
  query_types[5]{category,full_name,statements,purpose}:
    DDL,Data Definition Language,"CREATE, ALTER, DROP, TRUNCATE",Define and modify database schema
    DML,Data Manipulation Language,"SELECT, INSERT, UPDATE, DELETE",Query and modify data
    DCL,Data Control Language,"GRANT, REVOKE",Manage user permissions
    TCL,Transaction Control Language,"COMMIT, ROLLBACK, SAVEPOINT",Manage database transactions
    DQL,Data Query Language,SELECT,Query data (subset of DML)