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