Book Contents

Book Index

Next Topic

Home

SQL Commands

The Vertica documentation makes a distinction between SQL commands and statements. A command is an SQL keyword that specifies the imperative verb in a statement. A statement is a complete SQL command that can be executed. For example, SELECT is a command while SELECT C1 FROM T1 is a statement (with or without a semicolon).

In This Chapter

ALTER PROJECTION

ALTER TABLE

ALTER USER

COMMIT

COPY

CREATE PROJECTION

CREATE TABLE

CREATE TEMPORARY TABLE

CREATE USER

DELETE

DROP PROJECTION

DROP TABLE

DROP USER

EXPLAIN

GRANT (Schema)

GRANT (Table)

INSERT

LCOPY

REVOKE (Schema)

REVOKE (Table)

ROLLBACK

SELECT

SET

SHOW

UPDATE