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 “%”.
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.