Skip to Content
avatar image
Former Member

How to Reduce the field length in HANA table ?

Hi Experts,

Is there any possible ways to reduce the length of a field in the existing HANA table ?

Data has been dropped and dependent objects are also removed.

Still giving error while activation.

Thanks,

Devi.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 24, 2014 at 04:35 AM

    Hi Devi -

    There are some restrictions in altering the table . Please have a look at the

    ALTER TABLE - SAP HANA SQL and System Views Reference - SAP Library

    In your case you can drop and recreate the table.

    Thanks 😊

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Devi-

      When there is no dependency and data is also not present ,then the table can be dropped and can be recreated right.

      Thanks 😊