Subject How to get a list of columns from another select
Author

Hello everyone:


Is there a way I can select out the column names from any query? 

Ideally something like:


Select column_names From (Subquery)


I do not want the query results, I want the names of the columns.


Example

Select column_names From (Select NumberInst As #Inst, DescInst As Description, Type From Instrument Where NumberInst = 10)

I want get:

#Inst

Description

Type


Thank you so much.

Jorge B