reference/SQLCommandReference.html.md.erb

---
title: SQL Commands
---

This section contains a description and the syntax of the SQL commands supported by HAWQ.

-   **[ABORT](../reference/sql/ABORT.html)**

-   **[ALTER AGGREGATE](../reference/sql/ALTER-AGGREGATE.html)**

-   **[ALTER DATABASE](../reference/sql/ALTER-DATABASE.html)**

-   **[ALTER FUNCTION](../reference/sql/ALTER-FUNCTION.html)**

-   **[ALTER OPERATOR](../reference/sql/ALTER-OPERATOR.html)**

-   **[ALTER OPERATOR CLASS](../reference/sql/ALTER-OPERATOR-CLASS.html)**

-   **[ALTER RESOURCE QUEUE](../reference/sql/ALTER-RESOURCE-QUEUE.html)**

-   **[ALTER ROLE](../reference/sql/ALTER-ROLE.html)**

-   **[ALTER TABLE](../reference/sql/ALTER-TABLE.html)**

-   **[ALTER TABLESPACE](../reference/sql/ALTER-TABLESPACE.html)**

-   **[ALTER TYPE](../reference/sql/ALTER-TYPE.html)**

-   **[ALTER USER](../reference/sql/ALTER-USER.html)**

-   **[ANALYZE](../reference/sql/ANALYZE.html)**

-   **[BEGIN](../reference/sql/BEGIN.html)**

-   **[CHECKPOINT](../reference/sql/CHECKPOINT.html)**

-   **[CLOSE](../reference/sql/CLOSE.html)**

-   **[COMMIT](../reference/sql/COMMIT.html)**

-   **[COPY](../reference/sql/COPY.html)**

-   **[CREATE AGGREGATE](../reference/sql/CREATE-AGGREGATE.html)**

-   **[CREATE DATABASE](../reference/sql/CREATE-DATABASE.html)**

-   **[CREATE EXTERNAL TABLE](../reference/sql/CREATE-EXTERNAL-TABLE.html)**

-   **[CREATE FUNCTION](../reference/sql/CREATE-FUNCTION.html)**

-   **[CREATE GROUP](../reference/sql/CREATE-GROUP.html)**

-   **[CREATE LANGUAGE](../reference/sql/CREATE-LANGUAGE.html)**

-   **[CREATE OPERATOR](../reference/sql/CREATE-OPERATOR.html)**

-   **[CREATE OPERATOR CLASS](../reference/sql/CREATE-OPERATOR-CLASS.html)**

-   **[CREATE RESOURCE QUEUE](../reference/sql/CREATE-RESOURCE-QUEUE.html)**

-   **[CREATE ROLE](../reference/sql/CREATE-ROLE.html)**

-   **[CREATE SCHEMA](../reference/sql/CREATE-SCHEMA.html)**

-   **[CREATE SEQUENCE](../reference/sql/CREATE-SEQUENCE.html)**

-   **[CREATE TABLE](../reference/sql/CREATE-TABLE.html)**

-   **[CREATE TABLE AS](../reference/sql/CREATE-TABLE-AS.html)**

-   **[CREATE TABLESPACE](../reference/sql/CREATE-TABLESPACE.html)**

-   **[CREATE TYPE](../reference/sql/CREATE-TYPE.html)**

-   **[CREATE USER](../reference/sql/CREATE-USER.html)**

-   **[CREATE VIEW](../reference/sql/CREATE-VIEW.html)**

-   **[DEALLOCATE](../reference/sql/DEALLOCATE.html)**

-   **[DECLARE](../reference/sql/DECLARE.html)**

-   **[DROP AGGREGATE](../reference/sql/DROP-AGGREGATE.html)**

-   **[DROP DATABASE](../reference/sql/DROP-DATABASE.html)**

-   **[DROP EXTERNAL TABLE](../reference/sql/DROP-EXTERNAL-TABLE.html)**

-   **[DROP FILESPACE](../reference/sql/DROP-FILESPACE.html)**

-   **[DROP FUNCTION](../reference/sql/DROP-FUNCTION.html)**

-   **[DROP GROUP](../reference/sql/DROP-GROUP.html)**

-   **[DROP OPERATOR](../reference/sql/DROP-OPERATOR.html)**

-   **[DROP OPERATOR CLASS](../reference/sql/DROP-OPERATOR-CLASS.html)**

-   **[DROP OWNED](../reference/sql/DROP-OWNED.html)**

-   **[DROP RESOURCE QUEUE](../reference/sql/DROP-RESOURCE-QUEUE.html)**

-   **[DROP ROLE](../reference/sql/DROP-ROLE.html)**

-   **[DROP SCHEMA](../reference/sql/DROP-SCHEMA.html)**

-   **[DROP SEQUENCE](../reference/sql/DROP-SEQUENCE.html)**

-   **[DROP TABLE](../reference/sql/DROP-TABLE.html)**

-   **[DROP TABLESPACE](../reference/sql/DROP-TABLESPACE.html)**

-   **[DROP TYPE](../reference/sql/DROP-TYPE.html)**

-   **[DROP USER](../reference/sql/DROP-USER.html)**

-   **[DROP VIEW](../reference/sql/DROP-VIEW.html)**

-   **[END](../reference/sql/END.html)**

-   **[EXECUTE](../reference/sql/EXECUTE.html)**

-   **[EXPLAIN](../reference/sql/EXPLAIN.html)**

-   **[FETCH](../reference/sql/FETCH.html)**

-   **[GRANT](../reference/sql/GRANT.html)**

-   **[INSERT](../reference/sql/INSERT.html)**

-   **[PREPARE](../reference/sql/PREPARE.html)**

-   **[REASSIGN OWNED](../reference/sql/REASSIGN-OWNED.html)**

-   **[RELEASE SAVEPOINT](../reference/sql/RELEASE-SAVEPOINT.html)**

-   **[RESET](../reference/sql/RESET.html)**

-   **[REVOKE](../reference/sql/REVOKE.html)**

-   **[ROLLBACK](../reference/sql/ROLLBACK.html)**

-   **[ROLLBACK TO SAVEPOINT](../reference/sql/ROLLBACK-TO-SAVEPOINT.html)**

-   **[SAVEPOINT](../reference/sql/SAVEPOINT.html)**

-   **[SELECT](../reference/sql/SELECT.html)**

-   **[SELECT INTO](../reference/sql/SELECT-INTO.html)**

-   **[SET](../reference/sql/SET.html)**

-   **[SET ROLE](../reference/sql/SET-ROLE.html)**

-   **[SET SESSION AUTHORIZATION](../reference/sql/SET-SESSION-AUTHORIZATION.html)**

-   **[SHOW](../reference/sql/SHOW.html)**

-   **[TRUNCATE](../reference/sql/TRUNCATE.html)**

-   **[VACUUM](../reference/sql/VACUUM.html)**