SQL Query Types Reference
Categories of SQL statements for data definition, manipulation, and control.
The data
Query types
| 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) |
Fetch the same bytes
The static files are identical to what the API returns, but with no rate limit and no server round trip. Use the API when you want a query and a content type; use the files when you want to cache one document.
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 →