TEXTIMAGE_ON
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
TEXTIMAGE_ON [PRIMARY]
is a way in Transact to handle the large information groups inside a table. In Snowflake it is not required to define these kinds of characteristics because Snowflake handles large data files or information in a different arrangement.
Sample Source Patterns
Notice that in this example the TEXTIMAGE_ON [PRIMARY]
has been removed due to the unnecessary syntax.
CREATE TABLE [dbo].[TEST_Person](
[date_updated] [datetime] NULL
) TEXTIMAGE_ON [PRIMARY]
CREATE OR REPLACE TABLE dbo.TEST_Person (
date_updated TIMESTAMP_NTZ(3) NULL
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"transact"}}'
;
Last updated