Subject | How to get a list of columns from another select |
---|---|
Author | |
Post date | 2017-01-25T18:53:48Z |
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