SQL Command Reference

The following SQL commands are available in Greenplum Database:

• SQL Syntax Summary

• ABORT

• ALTER AGGREGATE

• ALTER CONVERSION

• ALTER DATABASE

• ALTER DOMAIN

• ALTER EXTENSION

• ALTER EXTERNAL TABLE

• ALTER FILESPACE

• 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 SCHEMA

• ALTER SEQUENCE

• ALTER TABLE

• ALTER TABLESPACE

• ALTER TRIGGER

• ALTER TYPE

• ALTER USER

• ALTER VIEW

• ANALYZE

• BEGIN

• CHECKPOINT

• CLOSE

• CLUSTER

• COMMENT

• COMMIT

• COPY

• CREATE AGGREGATE

• CREATE CAST

• CREATE CONVERSION

• CREATE DATABASE

• CREATE DOMAIN

• CREATE EXTENSION

• CREATE EXTERNAL 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 TABLE

• CREATE TABLE AS

• CREATE TABLESPACE

• CREATE TRIGGER

• CREATE TYPE

• CREATE USER

• CREATE VIEW

• DEALLOCATE

• DECLARE

• DELETE

• DISCARD

• DO

• DROP AGGREGATE

• DROP CAST

• DROP CONVERSION

• DROP DATABASE

• DROP DOMAIN

• DROP EXTENSION

• DROP EXTERNAL TABLE

• DROP FILESPACE

• 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 TABLE

• DROP TABLESPACE

• DROP TRIGGER

• DROP TYPE

• DROP USER

• DROP VIEW

• END

• EXECUTE

• EXPLAIN

• FETCH

• GRANT

• INSERT

• LOAD

• LOCK

• MOVE

• PREPARE

• REASSIGN OWNED

• REINDEX

• RELEASE SAVEPOINT

• RESET

• REVOKE

• ROLLBACK

• ROLLBACK TO SAVEPOINT

• SAVEPOINT

• SELECT

• SELECT INTO

• SET

• SET ROLE

• SET SESSION AUTHORIZATION

• SET TRANSACTION

• SHOW

• START TRANSACTION

• TRUNCATE

• UPDATE

• VACUUM

• VALUES

Parent topic: Greenplum Database Reference Guide