Wildcards | Teradata Vantage - Wildcards - Teradata Workload Management - Database Engine 20

You can use two wildcard characters anywhere in character strings representing DBS object names:

• The “*” wildcard character means match zero or more subsequent characters
• The “?” wildcard character means accept any legitimate character at this place in the string

Note the following examples:

• User names “ABC*” means all users with names beginning with “ABC” (including the name “ABC”)
• User names “A*C” means all users with names beginning with “A” and ending with “C” (including the name “AC”)
• Table names “DB1.T?BLE*” means all tables in database DB1 with names beginning with “T_BLE” where the second character could be any character
• Stored procedures “*.*” means all stored procedures in all databases

You can use multiples of these wildcard characters. For example:

• User names “A*B*C” means all users with names beginning with “A” and ending with “C,” with a “B” somewhere in the middle
• Table names “DB1.T???E” means all tables in database DB1 with names consisting of 5 characters beginning with “T” and ending with an “E”