SQL Query Types Reference
Categories of SQL statements for data definition, manipulation, and control.
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 it when
- You need to classify a SQL statement or explain the categories to a newcomer.
- You are setting permissions by statement category.
Watch out for
- 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.
The data
Query types
5 rows
| 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) |
Fields
The shape of this dataset, read from the data itself: every column, its type and a real value. Agents can use this to plan a query without fetching the whole document.
| 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 |
Fetch the same bytes
The static files contain the same reference rows as the API, with no API rate limit. Live metadata, such as view counts, may differ. Use the API for content negotiation; use the static files for a cacheable snapshot.
curl "https://yjtoon.com/api/dataset/sql-query-types?format=toon"
const res = await fetch( "https://yjtoon.com/static-data/dataset/sql-query-types.toon" ); const toon = await res.text();
Rate limit: 120 requests per minute per IP, no key and no signup. API reference →