> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported Statements

<a id="sql-procedures-statements" />

The following statement types are allowed within a *SQL procedure*:

* `SELECT`
* `INSERT` *(inserting from data file not supported)*
* `UPDATE`
* `DELETE`
* `CHECK PERMISSION`
* `<CREATE | DROP | SHOW CREATE> SCHEMA`
* `<CREATE | TRUNCATE | DROP | SHOW CREATE> TABLE`
* `CREATE TABLE ... AS`
* `<CREATE [MATERIALIZED] | REFRESH | DROP | SHOW CREATE> VIEW`
* `DESCRIBE`
* `EXECUTE FUNCTION`
* `EXECUTE PROCEDURE`
* `REFRESH MATERIALIZED VIEW`
* `SHOW PROCEDURE`
* `SHOW SECURITY [FOR <USER | ROLE>]`
* `SHOW RESOURCE GROUP`

<Info>
  Any unqualified table/view references made within the *SQL procedure*
  will be assumed to exist in the creator's default schema at the time of
  creation.  Those references will be set upon creation and never re-evaluated
  afterwards, regardless of the execution type of the *SQL procedure*, who
  executes it, or what `EXECUTE AS` option is specified.
</Info>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.