-- Create a backup of the table (optional, but recommended)
CREATE TABLE your_table_backup AS SELECT * FROM your_table;
-- Create a new temporary column without the identity attribute
ALTER TABLE your_table ADD (new_column INT);
-- Copy the data from the existing column to the new column
UPDATE your_table SET new_column = existing_column;
-- Drop the existing column
ALTER TABLE your_table DROP COLUMN existing_column;
-- Rename the new column to the original column name
ALTER TABLE your_table RENAME COLUMN new_column TO existing_column;