# Procedural SQL Reference

This section contains topics about SingleStoreProcedural SQL (PSQL), which encompasses stored procedures, user-defined scalar-value functions (UDFs), user-defined table-valued functions (TVFs), and user-defined aggregate functions (UDAFs).

* [Control Flow Statements](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/control-flow-statements.md)
* [Exceptions and Exception Handling](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/exceptions-and-exception-handling.md)
* [MySQL Client Delimiters](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/mysql-client-delimiters.md)
* [Transactions in Stored Procedures](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/transactions-in-stored-procedures.md)
* [CREATE FUNCTION (UDF)](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-function-udf.md)
* [CREATE FUNCTION (TVF)](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-function-tvf.md)
* [CREATE PROCEDURE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-procedure.md)
* [CREATE AGGREGATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-aggregate.md)
* [DROP FUNCTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/drop-function.md)
* [DROP PROCEDURE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/drop-procedure.md)
* [DROP AGGREGATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/drop-aggregate.md)
* [SHOW CREATE FUNCTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-create-function.md)
* [SHOW CREATE AGGREGATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-create-aggregate.md)
* [SHOW FUNCTIONS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-functions.md)
* [SHOW AGGREGATES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-aggregates.md)
* [ARRAY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/array.md)
* [CALL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/call.md)
* [INSERT\_ALL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/insert-all.md)
* [CREATE\_ARRAY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-array.md)
* [COLLECT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/collect.md)
* [ECHO](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/echo.md)
* [ECHO SELECT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/echo-select.md)
* [EXECUTE IMMEDIATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/execute-immediate.md)
* [RECORD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/record.md)
* [ROW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/row.md)
* [QUERY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/query.md)
* [SCALAR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/scalar.md)
* [TO\_QUERY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/to-query.md)

***

Modified at: June 5, 2023

Source: [/db/v9.1/developer-resources/procedural-extensions/procedural-sql-reference/](https://docs.singlestore.com/db/v9.1/developer-resources/procedural-extensions/procedural-sql-reference/)

(An index of the documentation is available at /llms.txt)