HANA auto identity column

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