View Defination

[Former Member]

How to get view defination in HANA by query?

[Ravi_Channe · Accepted solution]

Hi Sunny,

Use the following statement:

SELECT view_name, schema_name, definition FROM views WHERE schema_name = 'MYSCHEMA';

You can even say SELECT * and use the column definition to get the SQL code for the view.

I hope you are talking about DB views and not Information model views.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravindra,

Thanks for the reply.

Actually i wanted to know how to get metadata/column names of a view/table.

[Ravi_Channe · Accepted solution]

select schema_name, table_name, column_name from table_columns where table_name = 'MYTABLE';

select schema_name, table_name, column_name from view_columns where view_name = 'MYVIEW';

Or you can say select * ....

Regards,

Ravi