HANA auto identity column

[Former Member]

Hi All,

Any help much appreciated , I have some 500 tables in a schema and all the 500 table has auto identity column , in some table auto identity column is the primary key as well but for other table their is no primary key but with identity column.

My requirement is to delete the auto identity on the tables ??

I searched many documents and google but did not see an option to delete auto identity, is their a way i can do that ?? other than drop and recreate the table without identity column ??

Thanks in Advance

[eason_chen]

Hi,

You could use following SQL to drop the column.
ALTER TABLE T DROP ("<column name>")

In case the column is primary key. You have to first drop the primary key and recreate it with other columns.
ALTER TABLE T DROP PRIMARY KEY

Best Regards,
Eason Chen

[Former Member]

Thanks for the replying Eason , my requirement is to drop or disable only the auto identity feature in the column not to drop the whole column nor drop the primary key in the column .

Thanks

[Former Member]

Many Thanks Eason

[eason_chen]

Hi Dilip,

The feature to modify identity column is not supported. You could refer to following guide.
https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20d329a6751910149d5fdbc480...

The sequence defined for an IDENTITY column cannot be altered or reset after table creation.