api: "YAML JSON TOON Database"
version: 1.0.0
format: toon
dataset:
  id: 491
  slug: sql-query-types
  title: "SQL Query Types Reference"
  description: "Categories of SQL statements for data definition, manipulation, and control."
  category: "Database Types"
  category_slug: database-types
  tags: "sql,database,query,reference"
  view_count: 4
  created_at: 1781275786
  updated_at: 1781275786
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)"