17.10 - Wildcard Characters in Names - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update

Use wildcard characters % and ? to specify a pattern for database names or table names.

The following table shows how CheckTable interprets wildcard characters.

Wildcard character … Matches any …
% (percent sign) string of characters of any length, including the Null string.
? (question mark) single character.

You can use wildcard characters in any combination. However, you cannot use wildcard characters in hexadecimal form.

The following table shows the use of wildcard characters in names.

Wildcard character … Matches any …
% database name.
%.% table name.
%database% database name containing the string: database.
SalesDB% database name beginning with the following: SalesDB.

CheckTable supports the use of wildcard syntax to represent a list of possible characters at a particular position in the names of databases or tables. Use the wildcard syntax to specify lists of tables and databases you want CheckTable to check or not check. The wildcard syntax begins with a left square bracket ([) and ends with a right square bracket (]).

Other special characters can appear in table or database names but not in wildcard syntax. If any syntax error occurs in the wildcard syntax, then CheckTable aborts, and an error message appears.

For rules regarding use of Kanji and other Japanese characters in names, see Teradata Vantage™ - SQL Fundamentals, B035-1141. For information on syntax error messages, see Syntax Error Messages.