Alter Table translation planned to be delivered in the future.
This EWI is added when SnowConvert detects instances of ALTER TABLE statements. The ALTER TABLE is supported by Snowflake, but its transformation is not supported by SnowConvert at this moment. This kind of statements should be migrated manually if there are ocurrences in the source code.
ALTER TABLE MyTable ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL;
-- ** MSC-ERROR - MSCEWI4048 - TRANSLATION FOR ALTER TABLE IS PLANNED TO BE DELIVERED IN THE FUTURE **
--ALTER TABLE PUBLIC.MyTable
--ALTER COLUMN NullCOl VARCHAR(20) NOT NULL;
- Use a regular expression in order to match the ALTER TABLE pattern and remove the invalid syntax in Snowflake. For example:
ALTER TABLE dbo.Claimant ADD CONSTRAINT DF_Claimant_ClaimID DEFAULT ((0)) FOR ClaimID;
- 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.