Skip to main content

Temporal Table Pattern Name

The string to add to the Temporal PSA objects when Staging and Persistent Staging are co-located in the same database.

When a PSA table is generated as a SQL Server temporal (system-versioned) table, the create script names the history table as the table name followed by this value, in the same schema — SYSTEM_VERSIONING = ON (HISTORY_TABLE = [schema].[TableName{value}]).

When to Change This Setting​

The default History names each temporal history table <TableName>History. Change it only to match your naming convention for temporal history tables.

Notes​

  • This setting is part of the Staging Persistent settings category.
  • The default value for this setting is History.