on 06-06-2018 9:02 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.