The SQL commands listed here are either different from standard SQL implementations due to Redshift needs or are otherwise important to highlight. This is not a SQL reference; most SQL that you will run in Redshift will function as you would expect it to normally.
- ALTER: This command is at the table level only; there are no alter column commands (see Chapter 5, Querying Data).
- ANALYZE: The command used to capture statistical information about a table for use by the query planner (see Chapter 4, Managing Your Data).
- COPY: The following screenshot shows the syntax of this command (see Chapter 3, Loading Your Data to Redshift):
- CREATE TABLE ...