Teradata sql assistant - Tools/List Columns issue with wildcard %

Tools & Utilities
Fan

Teradata sql assistant - Tools/List Columns issue with wildcard %

TD SQL Assistant menu option? Tools ? List Columns not working properly with wildcard %.

Teradata SQL Assistant -> “Tools” and then “List Columns”,
database name of “XXXX” and table/view name of “%”.

failed with "The Database or Table is invalid or unavailable"

If I use “C%” as the tablename in the Teradata SQL Assistant Tool it will work, pulling all of the columns in all of the tables beginning with “C”. It just doesn’t work if I try to pull all of the tables “with just “%”.

for some database its working fine with wildcard "table or view name" of “%”.

fyi, having full access on database
2 REPLIES
Enthusiast

Re: Teradata sql assistant - Tools/List Columns issue with wildcard %

I've tried the same thing to fetch the list of columns with % as table name - and it's resulting out with all the columns in that database. So % should work...
Currently I'm using version 7.2.0.03 of Teradata SQL Assistant.
Enthusiast

Re: Teradata sql assistant - Tools/List Columns issue with wildcard %

hi

I did not get any results for the first time.
In the next attempt, I used ' %' and it retrieved all values. After that, I used '%' and all the columns were retrieved from all columns.