There is an ambiguos approach in your message, in your header, you are asking about the name of a particular column and in the body, you are asking about all the column names, I've attached an example file with a possible solution.
I hope this help you.
Here is again my solution:
ODBC CONNECT TO [XXX;DBQ=ZZZZZ ] (XUserId is MPBZQIRNJbaMXUVMXLSB, XPassword is UaaZNDBGSKTSUDFIMSMADYEHYA);
LOAD "OWNER", "TABLE_NAME";
SQL SELECT "OWNER", "TABLE_NAME"
where "OWNER" = 'QlikView';
LOAD "TABLE_NAME", "COLUMN_NAME";
SQL SELECT "TABLE_NAME", "COLUMN_NAME"
where "OWNER" = 'Qlikview';
Hope this help you.