Skip to main content

Delete Schema Name Pattern

The name to use for the Delete objects schema when using Delete detection. @@rs uses the Record Source of the connection as schema. (This is the same default behavior as for the Staging tables). Update this to use a specific schema for delete tables.

The pattern supports three tokens: @@rs (the Record Source code), @@stage (the landing affix, or the external affix on Azure Synapse targets) and @@schema (the object's original schema, dbo when blank). The pattern applies to objects in the delete-detection integration stage; when it is blank, the delete objects follow the same schema behavior as the staging tables.

When to Change This Setting​

Keep the default @@rs to keep delete objects alongside their staging tables in the record-source schema. Change it when delete tables should be isolated in their own schema — for example a fixed del schema.

SettingInteraction
Delete Object Name PatternThe equivalent pattern for the delete objects' name
Schema Name PatternThe equivalent pattern for regular staging tables
Delete Detection EnabledEnables delete detection overall

Notes​

  • This setting is part of the Staging Naming settings category.
  • The default value for this setting is @@rs.