ON PARTITION

Applies to

• SQL Server

Non-relevant statement.

Notice that this statement is removed from the migration because it is a non-relevant syntax. It means that it is not required in Snowflake.

Description

Some parts in the output code are omitted for clarity reasons.

In Transact SQL Server, the on partition statement is used inside alter statements and is used to divide the data across the database. Review more information here.

Sample Source Patterns

On Partition

Notice that in this example the ON PARTITION has been removed. This is because Snowflake provides an integrated partitioning methodology. Thus, the syntax is not relevant.

SqlServer

IN -> SqlServer_01.sql

ALTER TABLE table_name
ADD column_name INTEGER
CONSTRAINT constraint_name UNIQUE
ON partition_scheme_name (partition_column_name);

Snowflake

OUT -> SqlServer_01.sql

ALTER TABLE table_name
ADD column_name INTEGER
CONSTRAINT constraint_name UNIQUE;

Known Issues

No issues were found.

Related EWIs

No related EWIs.