About
SQL Statements are the language of a database.
A SQL file contains one or more SQL statements that are send to the database.
Attributes
Subset
In SQL, statements are classified by subset. The most known are:
- Data Manipulation Language (DML) (select, update, insert, merge)
- Data Definition Language (DDL) (create, alter, drop)
- Data Control Language (DCL) (grant/revoke)
When parsing a SQL file in SQL mode, you get this information in the subset column.
Note that all SQL statements can not be categorically categorized. For instance, the Sqlite Pragma can:
- get a result with the Sqlite Pragma function
- set parameters PRAGMA analysis_limit = N;
Name
The statement name.
Example of values:
- select
- with
- update
- create
When parsing a SQL file in SQL mode, you get this information in the name column.
Parameters
SQL Statement may be parameterized to receive arguments known as parameters