Snowflake CREATE TABLE SQL Reference (2026)

Official Snowflake SQL reference for the CREATE TABLE command.

Key facts surfaced (2026-05-19):

• Creates new tables, replaces existing, or alters existing tables in the current/specified schema.
• Key syntax variants: CREATE TABLE … AS SELECT (CTAS), CREATE TABLE … CLONE, CREATE TABLE … LIKE (schema copy without data).
• Supports inline and out-of-line constraints for column definitions.
• Extensive options for data governance, clustering, time travel retention, and masking policies.
• Curriculum reference: equivalent to AEP Dataset provisioning for the composable CDP learning path (Module 2).