O'Reilly logo

Getting Started with Amazon Redshift by Stefan Bauer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL commands

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):
    SQL commands
  • CREATE TABLE ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required