Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Glossary

Replace Table Action Symbols

Replace Table Action Symbols

You can use symbols to specify which part of the SQL statement you want to replace.
Use the \(table), \(prefix), and \(tableOnly) symbols in the Alternative Object or Query field to replace part or all of the FROM clause of the current SQL request.
The following table describes the Replace Table action symbols:
Symbol
Description
\(table)
Replaces the full object reference in the original SQL statement with the Table Name parameter value.
\(prefix)
Replaces the prefix of the object reference, including the separator, with the Table Name parameter value.
\(tableOnly)
Replaces the table name with the Table Name parameter value, but preserves the path.
For example, you want to use symbols to alter the following statement:
SELECT * FROM [HR].[DBO].employee
The following table describes which parts of the SQL statement the symbols replace:
Symbol
Replaced Value
\(table)
[HR].[DBO].employee
\(prefix)
[HR].[DBO].
\(tableOnly)
employee