CREATE TABLE [dbo].[data_load]
(
[ID] [INT] NOT NULL,
[PC] [INT] NOT NULL,
[AM_System_Type] [VARCHAR](50) NOT NULL,
[PeriodKey] [VARCHAR](50) NOT NULL,
[File_Path] [VARCHAR](4000) NOT NULL,
[Fale_Name] [VARCHAR](255) NOT NULL,
[File_Type] [VARCHAR](50) NOT NULL,
[Status] [VARCHAR](255) NULL,
[PlaceHolder1] [VARCHAR](4000) NULL,
[PlaceHolder2] [VARCHAR](4000) NULL,
[SysStartTime] [DATETIME2] GENERATED ALWAYS AS ROW START NOT NULL,
[SysEndTime] [DATETIME2] GENERATED ALWAYS AS ROW END NOT NULL,
PERIOD FOR SYSTEM_TIME (SysStartTime, SysEndTime),
CONSTRAINT [PK_data_load] PRIMARY KEY CLUSTERED
(
[ID] ASC
)
) --Needed to close the column definition section
ON [PRIMARY] --This goes between the column definition section and the table options WITH section
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.data_load_history) )
GO
There are a couple issues I see. The column definition section did not have its closing parentheses, and the ON was placed incorrectly.
I've fixed those above.
Cheers!