Greenplum database SQL Command Reference

References for the SQL commands available in Greenplum.
  1. ABORT
  2. ALTER AGGREGATE
  3. ALTER CONVERSION
  4. ALTER DATABASE
  5. ALTER DOMAIN
  6. ALTER EXTERNAL TABLE
  7. ALTER FILESPACE
  8. ALTER FOREIGN DATA WRAPPER*
  9. ALTER FOREIGN TABLE*
  10. ALTER FUNCTION
  11. ALTER GROUP
  12. ALTER INDEX
  13. ALTER LANGUAGE
  14. ALTER OPERATOR
  15. ALTER OPERATOR CLASS
  16. ALTER RESOURCE QUEUE
  17. ALTER ROLE
  18. ALTER SCHEMA
  19. ALTER SEQUENCE
  20. ALTER SERVER*
  21. ALTER TABLE
  22. ALTER TABLESPACE
  23. ALTER TRIGGER
  24. ALTER TYPE
  25. ALTER USER
  26. ALTER USER MAPPING*
  27. ANALYZE
  28. BEGIN
  29. CHECKPOINT
  30. CLOSE
  31. CLUSTER
  32. COMMENT
  33. COMMIT
  34. COPY
  35. CREATE AGGREGATE
  36. CREATE CAST
  37. CREATE CONVERSION
  38. CREATE DATABASE
  39. CREATE DOMAIN
  40. CREATE EXTERNAL TABLE
  41. CREATE FOREIGN DATA WRAPPER*

  1. CREATE FOREIGN TABLE*
  2. CREATE FUNCTION
  3. CREATE GROUP
  4. CREATE INDEX
  5. CREATE LANGUAGE
  6. CREATE OPERATOR
  7. CREATE OPERATOR CLASS
  8. CREATE RESOURCE QUEUE
  9. CREATE ROLE
  10. CREATE RULE
  11. CREATE SCHEMA
  12. CREATE SEQUENCE
  13. CREATE SERVER*
  14. CREATE TABLE
  15. CREATE TABLE AS
  16. CREATE TABLESPACE
  17. CREATE TRIGGER
  18. CREATE TYPE
  19. CREATE USER
  20. CREATE USER MAPPING*
  21. CREATE VIEW
  22. DEALLOCATE
  23. DECLARE
  24. DELETE
  25. DROP AGGREGATE
  26. DROP CAST
  27. DROP CONVERSION
  28. DROP DATABASE
  29. DROP DOMAIN
  30. DROP EXTERNAL TABLE
  31. DROP FILESPACE
  32. DROP FOREIGN DATA WRAPPER*
  33. DROP FOREIGN TABLE*
  34. DROP FUNCTION
  35. DROP GROUP
  36. DROP INDEX
  37. DROP LANGUAGE
  38. DROP OPERATOR
  39. DROP OPERATOR CLASS
  40. DROP OWNED


    1. DROP RESOURCE QUEUE
    2. DROP ROLE
    3. DROP RULE
    4. DROP SCHEMA
    5. DROP SEQUENCE
    6. DROP SERVER*
    7. DROP TABLE
    8. DROP TABLESPACE
    9. DROP TRIGGER
    10. DROP TYPE
    11. DROP USER
    12. DROP USER MAPPING*
    13. DROP VIEW
    14. END
    15. EXECUTE
    16. EXPLAIN
    17. FETCH
    18. GRANT
    19. INSERT
    20. LOAD
    21. LOCK
    22. MOVE
    23. PREPARE
    24. REASSIGN OWNED
    25. REINDEX
    26. RELEASE SAVEPOINT
    27. RESET
    28. REVOKE
    29. ROLLBACK
    30. ROLLBACK TO SAVEPOINT
    31. SAVEPOINT
    32. SELECT
    33. SELECT INTO
    34. SET
    35. SET ROLE
    36. SET SESSION AUTHORIZATION
    37. SET TRANSACTION
    38. SHOW
    39. START TRANSACTION
    40. TRUNCATE
    41. UPDATE
    42. VACUUM
    43. VALUES


    Comments