Discussion Board for collaboration on QlikView Scripting.
I have a new database that I am connecting to and i would like to use QlikView to show me all of the field names available in a certain table.
I have tried:
SQL SELECT *.*
This throws an error , am i unable to use a wild card for fields?
Below SQL script will return all the column names from a SQL table:
You could do it on the server, but as shown it will run from QlikView. However, that script will depend heavily on your environment, I believe. At our company, for instance, it would look more like:
WHERE TBCREATOR = 'SYSTLC'
AND TBNAME = 'VISITS'
But when I want to know the field names in a table, I do it like Sunny T suggested.