how to retrieve only the field names from a database view?

Gopi22 · ‎01-27-2016

Hi Friends,

How can i get all the field names from a particular database view? Is there anyway I can export all the fields from that database view?

Only the fields and not the data.

vijay152 · ‎01-27-2016

Hi Gopi,

if you go to the table sys_db_view_table_field and dot walk in the List Layout, you can see the View(Productline).

See the sample attached:

Database view fields.PNG

this will help you to get the list of fields used in that view

Gopi22 · ‎02-10-2016

Hi Vijay,

Along with the field names of the view, how can we get the label for those fields along with that?

Is there any way to do that?

Will help in many documentation.

Thanks,

Gopi