markdown/reference/SQLCommandReference.html.md.erb

---
title: SQL Commands
---

<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements.  See the NOTICE file
distributed with this work for additional information
regarding copyright ownership.  The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License.  You may obtain a copy of the License at

  http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied.  See the License for the
specific language governing permissions and limitations
under the License.
-->

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 SEQUENCE](../reference/sql/ALTER-SEQUENCE.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)**