| --- |
| 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)** |
| |
| |