[OLD] SnowConvert - LIMITED ACCESS
Ctrlk
  • SnowConvert Translation Reference
  • Licensing
  • Download and Access
  • For Teradata
    • Translation Reference
  • For Oracle
    • Translation Reference
  • For SQL Server
    • Translation Reference
  • ANSI SQL
    • Translation Reference
  • For PostgreSQL
    • Translation Reference
  • For IBM DB2
    • Translation Reference
  • For Greenplum
    • Translation Reference
  • For Amazon Redshift
    • Translation Reference
  • For Apache Hive
    • Translation Reference
  • For Vertica
    • Translation Reference
  • For Google BigQuery
    • Translation Reference
      • General Language Elements
      • Identifier differences between BigQuery and Snowflake
      • Data Types
      • Statements
        • SELECT
        • CREATE FUNCTION
        • CREATE TABLE
          • TABLE SCOPE
          • COLUMN DEFINITION
          • CONSTRAINT DEFINITION
          • TABLE OPTIONS
            • DEFAULT COLLATE
            • PARTITION BY
            • CLUSTER BY
            • OPTIONS CLAUSE
            • AS query_statement
        • CREATE TABLE LIKE
        • CREATE TABLE COPY
        • CREATE TABLE CLONE
        • CREATE SNAPSHOT TABLE
        • CREATE EXTERNAL TABLE
        • CREATE VIEW
        • CREATE MATERIALIZED VIEW
        • CREATE SCHEMA
        • CREATE TABLE FUNCTION
        • CREATE PROCEDURE
        • REPEAT STATEMENT
        • WHILE STATEMENT
      • Procedural Language
      • Built-in functions
  • FOR SPARK (SCALA)
    • Translation Reference
  • FOR SPARK SQL
    • Translation Reference
  • FOR PYSPARK (PYTHON)
    • Translation Reference
  • General
    • Extensibility in SnowConvert
  • Assessment Properties
Powered by GitBook
On this page

Was this helpful?

  1. For Google BigQuery
  2. Translation Reference
  3. Statements
  4. CREATE TABLE

TABLE OPTIONS

DEFAULT COLLATEPARTITION BYCLUSTER BYOPTIONS CLAUSEAS query_statement
PreviousCONSTRAINT DEFINITIONNextDEFAULT COLLATE

Was this helpful?