Comment on page
MSCEWI1102
Low
Snowflake statements could remove some options when they are handled by the conversion rule. So it will be removed from the output code but the functionality is equivalent.
-- Case 1:
TRUNCATE only table_base2 RESTART IDENTITY CASCADE;
-- Case 2:
truncate table table_inherit_and_generated RESTART IDENTITY CASCADE;
-- Case 1:
--** MSC-WARNING - MSCEWI1102 - REMOVED ONLY OPTION FROM CODE, ALREADY HANDLED IN CONVERSION TO SNOWFLAKE **
--** MSC-WARNING - MSCEWI1102 - REMOVED CASCADE OPTION FROM CODE, ALREADY HANDLED IN CONVERSION TO SNOWFLAKE **
--** MSC-WARNING - MSCEWI1102 - REMOVED RESTART IDENTITY OPTION FROM CODE, ALREADY HANDLED IN CONVERSION TO SNOWFLAKE **
TRUNCATE table_base2;
-- Case 2:
--** MSC-WARNING - MSCEWI1102 - REMOVED CASCADE OPTION FROM CODE, ALREADY HANDLED IN CONVERSION TO SNOWFLAKE **
--** MSC-WARNING - MSCEWI1102 - REMOVED RESTART IDENTITY OPTION FROM CODE, ALREADY HANDLED IN CONVERSION TO SNOWFLAKE **
TRUNCATE TABLE table_with_foreign_key_2;
CREATE OR REPLACE SEQUENCE table_inherit_and_generated_did
START 1
CLONE table_inherit_and_generated_did;
ALTER TABLE table_inherit_and_generated ALTER did SET DEFAULT table_inherit_and_generated_did.NEXTVAL;
TRUNCATE TABLE table_inherit_and_generated;
- No end-user action is required.