SQL Types

SQL statements are generally categorized into different types based on the tasks each statement can perform.

SQL TypeCommandsDescription
Data Definition Language (DDL)
  • CREATE
  • ALTER
  • DROP
  • TRUNCATE
Statements that define the data and data structure (schema objects).
Data Manipulation Language (DML)
  • INSERT
  • UPDATE
  • DELETE
Statements that manipulate the data.
Data Control Language (DCL)
  • GRANT
  • REVOKE
Statements to limit the access on the data.
Transact Control Language (TCL)
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
Statements to control the transactions in a session.
Data Query Language (DQL)
  • SELECT
Statements used to view the data.
Did you find this page helpful?
Start with GraphQL on Hasura for Free
  • ArrowBuild apps and APIs 10x faster
  • ArrowBuilt-in authorization and caching
  • Arrow8x more performant than hand-rolled APIs
Promo
footer illustration
Brand logo
© 2024 Hasura Inc. All rights reserved
Github
Titter
Discord
Facebook
Instagram
Youtube
Linkedin
graphql-handbook