Basic Table

The simplest CREATE TABLE according to the grammar.

Grammar Syntax

Click here to go to the ANSI SQL Standard specification for this syntax.

This syntax is fully supported by Snowflake.

Sample Source Patterns

ANSI SQL Input Code

CREATE TABLE TABLE01 (COLNAME VARCHAR(20));

Snowflake Output Code

CREATE TABLE TABLE01 (COLNAME VARCHAR(20));