Skip to Content
avatar image
Former Member

Is it possible to edit already created view in SAP HANA

Hello All,

In SAP HANA studio I have created a view graphically under a schema based on requirement. But now there is a requirement to add some more fields to this view. I tried to edit the view but I did not get any option to edit the view graphically.

Note:- This is a simple view not any attribute/analytic/calculation view.

Thanks & BR,

RD

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 16, 2013 at 10:49 AM

    Hi Rajib,

    If I understand correctly, you are talking about the database view created on a table(s). You can copy the CREATE VIEW statement from the view definition or generate the "CREATE VIEW" statement using Export SQL option. Then drop the existing view using DROP VIEW statement and re-create the view.

    I don't think there is any "ALTER VIEW" statement as of now.

    Regards,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Rajib,

      😊, agree with you. The DROP and CREATE is sort of a workaround for the missing functionality of ALTER VIEW.

      SE11 might also be doing the same (DROP and CREATE in the background) for HANA. I haven't tried altering the view in SE11 yet.

      Although most of the other databases provide ALTER VIEW command, is it not currently available in HANA.

      BTW, you can alter a TABLE and do not need to drop it to modify.

      Regards,

      Ravi

  • Jun 19, 2013 at 05:57 PM

    This is exactly why SAP recommends using the HANA Development artifacts instead of creating it directly in SQL Console, i.e. using the SAP HANA Development perspective in HANA Studio and creating a .hdbview file in a project shared against a package in some HANA Repository. This way, you'd be able to change and reactivate your procedures, transport them to QAS/PRD without having to manually rerun SQL commands etc.

    Best regards,

    Henrique.

    Add comment
    10|10000 characters needed characters exceeded