Copy a Table with an Identity to a Table with an Identity on the Same Database Keeping the Identities in Sync
Jim Knicely, Vertica Field Chief Technologist
May 25, 2020
An IDENTITY associates a table column with a sequence. This sequence automatically increments the column value as new rows are added. There are some noteable restrictions on IDENTITY columns: You cannot INSERT values manually into an IDENTITY column You cannot UPDATE the values of an IDENTITY column once they has been populated via the sequence...