The following SQL commands are available in Greenplum Database:

• ABORT
• ALTER AGGREGATE
• ALTER COLLATION
• ALTER CONVERSION
• ALTER DATABASE
• ALTER DEFAULT PRIVILEGES
• ALTER DOMAIN
• ALTER EXTERNAL TABLE
• ALTER FOREIGN DATA WRAPPER
• ALTER FOREIGN TABLE
• ALTER FUNCTION
• ALTER GROUP
• ALTER INDEX
• ALTER LANGUAGE
• ALTER OPERATOR
• ALTER OPERATOR CLASS
• ALTER OPERATOR FAMILY
• ALTER PROTOCOL
• ALTER RESOURCE GROUP
• ALTER RESOURCE QUEUE
• ALTER ROLE
• ALTER RULE
• ALTER SCHEMA
• ALTER SEQUENCE
• ALTER SERVER
• ALTER TABLE
• ALTER TABLESPACE
• ALTER TEXT SEARCH CONFIGURATION
• ALTER TEXT SEARCH DICTIONARY
• ALTER TEXT SEARCH PARSER
• ALTER TEXT SEARCH TEMPLATE
• ALTER TYPE
• ALTER USER
• ALTER USER MAPPING
• ALTER VIEW
• ANALYZE
• BEGIN
• CHECKPOINT
• CLOSE
• CLUSTER
• COMMENT
• COMMIT
• COPY
• CREATE AGGREGATE
• CREATE CAST
• CREATE COLLATION
• CREATE CONVERSION
• CREATE DATABASE
• CREATE DOMAIN
• CREATE EXTERNAL TABLE
• CREATE FOREIGN DATA WRAPPER
• CREATE FOREIGN TABLE
• CREATE FUNCTION
• CREATE GROUP
• CREATE INDEX
• CREATE LANGUAGE
• CREATE OPERATOR
• CREATE OPERATOR CLASS
• CREATE OPERATOR FAMILY
• CREATE PROTOCOL
• CREATE RESOURCE GROUP
• CREATE RESOURCE QUEUE
• CREATE ROLE
• CREATE RULE
• CREATE SCHEMA
• CREATE SEQUENCE
• CREATE SERVER
• CREATE TABLE
• CREATE TABLE AS
• CREATE TABLESPACE
• CREATE TEXT SEARCH CONFIGURATION
• CREATE TEXT SEARCH DICTIONARY
• CREATE TEXT SEARCH PARSER
• CREATE TEXT SEARCH TEMPLATE
• CREATE TYPE
• CREATE USER
• CREATE USER MAPPING
• CREATE VIEW
• DEALLOCATE
• DECLARE
• DELETE
• DISCARD
• DO
• DROP AGGREGATE
• DROP CAST
• DROP COLLATION
• DROP CONVERSION
• DROP DATABASE
• DROP DOMAIN
• DROP EXTERNAL TABLE
• DROP FOREIGN DATA WRAPPER
• DROP FOREIGN TABLE
• DROP FUNCTION
• DROP GROUP
• DROP INDEX
• DROP LANGUAGE
• DROP OPERATOR
• DROP OPERATOR CLASS
• DROP OPERATOR FAMILY
• DROP OWNED
• DROP PROTOCOL
• DROP RESOURCE GROUP
• DROP RESOURCE QUEUE
• DROP ROLE
• DROP RULE
• DROP SCHEMA
• DROP SEQUENCE
• DROP SERVER
• DROP TABLE
• DROP TABLESPACE
• DROP TEXT SEARCH CONFIGURATION
• DROP TEXT SEARCH DICTIONARY
• DROP TEXT SEARCH PARSER
• DROP TEXT SEARCH TEMPLATE
• DROP TYPE
• DROP USER
• DROP USER MAPPING
• DROP VIEW
• END
• EXECUTE
• EXPLAIN
• FETCH
• GRANT
• INSERT
• LISTEN
• LOAD
• LOCK
• MOVE
• NOTIFY
• PREPARE
• REASSIGN OWNED
• REINDEX
• RELEASE SAVEPOINT
• RESET
• RETRIEVE
• REVOKE
• ROLLBACK
• ROLLBACK TO SAVEPOINT
• SAVEPOINT
• SELECT
• SELECT INTO
• SET
• SET CONSTRAINTS
• SET ROLE
• SET SESSION AUTHORIZATION
• SET TRANSACTION
• SHOW
• START TRANSACTION
• TRUNCATE
• UNLISTEN
• UPDATE
• VACUUM
• VALUES

* Not implemented in 5.0

• SQL Syntax Summary

• ABORT

• ALTER AGGREGATE

• ALTER COLLATION

• ALTER CONVERSION

• ALTER DATABASE

• ALTER DEFAULT PRIVILEGES

• ALTER DOMAIN

• ALTER EXTENSION

• ALTER EXTERNAL TABLE

• ALTER FOREIGN DATA WRAPPER

• ALTER FOREIGN TABLE

• ALTER FUNCTION

• ALTER GROUP

• ALTER INDEX

• ALTER LANGUAGE

• ALTER MATERIALIZED VIEW

• ALTER OPERATOR

• ALTER OPERATOR CLASS

• ALTER OPERATOR FAMILY

• ALTER PROTOCOL

• ALTER RESOURCE GROUP

• ALTER RESOURCE QUEUE

• ALTER ROLE

• ALTER SCHEMA

• ALTER SEQUENCE

• ALTER SERVER

• ALTER TABLE

• ALTER TABLESPACE

• ALTER TEXT SEARCH CONFIGURATION

• ALTER TEXT SEARCH DICTIONARY

• ALTER TEXT SEARCH PARSER

• ALTER TEXT SEARCH TEMPLATE

• ALTER TRIGGER

• ALTER TYPE

• ALTER USER

• ALTER USER MAPPING

• ALTER VIEW

• ANALYZE

• BEGIN

• CHECKPOINT

• CLOSE

• CLUSTER

• COMMENT

• COMMIT

• COPY

• CREATE AGGREGATE

• CREATE CAST

• CREATE COLLATION

• CREATE CONVERSION

• CREATE DATABASE

• CREATE DOMAIN

• CREATE EXTENSION

• CREATE EXTERNAL TABLE

• CREATE FOREIGN DATA WRAPPER

• CREATE FOREIGN TABLE

• CREATE FUNCTION

• CREATE GROUP

• CREATE INDEX

• CREATE LANGUAGE

• CREATE MATERIALIZED VIEW

• CREATE OPERATOR

• CREATE OPERATOR CLASS

• CREATE OPERATOR FAMILY

• CREATE PROTOCOL

• CREATE RESOURCE GROUP

• CREATE RESOURCE QUEUE

• CREATE ROLE

• CREATE RULE

• CREATE SCHEMA

• CREATE SEQUENCE

• CREATE SERVER

• CREATE TABLE

• CREATE TABLE AS

• CREATE TABLESPACE

• CREATE TRIGGER

• CREATE TEXT SEARCH CONFIGURATION

• CREATE TEXT SEARCH DICTIONARY

• CREATE TEXT SEARCH PARSER

• CREATE TEXT SEARCH TEMPLATE

• CREATE TYPE

• CREATE USER

• CREATE USER MAPPING

• CREATE VIEW

• DEALLOCATE

• DECLARE

• DELETE

• DISCARD

• DO

• DROP AGGREGATE

• DROP CAST

• DROP COLLATION

• DROP CONVERSION

• DROP DATABASE

• DROP DOMAIN

• DROP EXTENSION

• DROP EXTERNAL TABLE

• DROP FOREIGN DATA WRAPPER

• DROP FOREIGN TABLE

• DROP FUNCTION

• DROP GROUP

• DROP INDEX

• DROP LANGUAGE

• DROP MATERIALIZED VIEW

• DROP OPERATOR

• DROP OPERATOR CLASS

• DROP OPERATOR FAMILY

• DROP OWNED

• DROP PROTOCOL

• DROP RESOURCE GROUP

• DROP RESOURCE QUEUE

• DROP ROLE

• DROP RULE

• DROP SCHEMA

• DROP SEQUENCE

• DROP SERVER

• DROP TABLE

• DROP TABLESPACE

• DROP TEXT SEARCH CONFIGURATION

• DROP TEXT SEARCH DICTIONARY

• DROP TEXT SEARCH PARSER

• DROP TEXT SEARCH TEMPLATE

• DROP TRIGGER

• DROP TYPE

• DROP USER

• DROP USER MAPPING

• DROP VIEW

• END

• EXECUTE

• EXPLAIN

• FETCH

• GRANT

• INSERT

• LOAD

• LOCK

• MOVE

• PREPARE

• REASSIGN OWNED

• REFRESH MATERIALIZED VIEW

• REINDEX

• RELEASE SAVEPOINT

• RESET

• RETRIEVE

• REVOKE

• ROLLBACK

• ROLLBACK TO SAVEPOINT

• SAVEPOINT

• SELECT

• SELECT INTO

• SET

• SET CONSTRAINTS

• SET ROLE

• SET SESSION AUTHORIZATION

• SET TRANSACTION

• SHOW

• START TRANSACTION

• TRUNCATE

• UPDATE

• VACUUM

• VALUES

Parent topic: Greenplum Database Reference Guide