|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/22/2009 10:35:50 AM
Posts: 4,
Visits: 21
|
|
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
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
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.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: Today @ 9:29:52 AM
Posts: 17,
Visits: 91
|
|
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.
SK
|
|
|
|