FOREIGN KEY
Description
SnowFlake supports the grammar for Referential Integrity Constraints, and their properties to facilitate the migration from other databases.
Syntax in SQL Server
Syntax in Snowflake
Sample Source Patterns
SQL Server
Snowflake
Constraints are not enforced in Snowflake, excepting NOT NULL.
Primary and Foreign Key are only used for documentation purposes more than design constraints.
Known Issues
No issues were found
Related EWIs
MSCEWI1042: Non-relevant syntax
Last updated