MSCEWI4011

Column sorting removed

Severity
Low
Description
This warning is added when a column in a table has ASC or DESC sorting specification. Since it is not allowed in Snowflake, it will be removed in the output code.
Code Example
Input Code:
CREATE TABLE "bb"."SRC"."T1"
(
  [id]  INT,
	CONSTRAINT [PK_at_ad] PRIMARY KEY ([id] ASC)
);
Output Code:
CREATE OR REPLACE TABLE "bb"."SRC"."T1" (
   id INT,
   CONSTRAINT PK_at_ad PRIMARY KEY (id /*** MSC-WARNING - MSCEWI4011 - Column sorting is not supported in Snowflake ***/)
);
Recommendations
No additional user actions are required, it is just informative.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI4010

MSCEWI4012

Last modified 1yr ago