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

Gopi22
Giga Guru

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.

1 ACCEPTED SOLUTION

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


View solution in original post

5 REPLIES 5

vijay152
Kilo Expert

Hi Gopi,



Run the report on this Table - sys_db_view_table_field, you will get the list of fields used in Database Views.


you will not get the table in Reports as its Sys Table, so go the Table i mentioned directly and generate your report.



Thanks,


Vijay


Hi Vijay,



Thanks for your help.


But what i want is :


I have a database view u_productline_view.


I want all the fields in this view exported. All the field names to be precise.


Is there any way to do that?


If there is a way, please help.



Thanks,


Gopi


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


Hi Vijay,



Thank you for the response. Helped a lot



Thanks,


Gopi