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:
    - You need to classify a SQL statement or explain the categories to a newcomer.
    - You are setting permissions by statement category.
  caveats:
    - 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:
    - 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:
    - section: query_types
      field: category
      type: string
      example: DDL
    - section: query_types
      field: full_name
      type: string
      example: Data Definition Language
    - section: query_types
      field: statements
      type: string
      example: CREATE, ALTER, DROP, TRUNCATE
    - section: query_types
      field: purpose
      type: string
      example: Define and modify database schema
data:
  query_types:
    - category: DDL
      full_name: Data Definition Language
      statements: CREATE, ALTER, DROP, TRUNCATE
      purpose: Define and modify database schema
    - category: DML
      full_name: Data Manipulation Language
      statements: SELECT, INSERT, UPDATE, DELETE
      purpose: Query and modify data
    - category: DCL
      full_name: Data Control Language
      statements: GRANT, REVOKE
      purpose: Manage user permissions
    - category: TCL
      full_name: Transaction Control Language
      statements: COMMIT, ROLLBACK, SAVEPOINT
      purpose: Manage database transactions
    - category: DQL
      full_name: Data Query Language
      statements: SELECT
      purpose: Query data (subset of DML)