Delete from IDENTITY Columns

You can use the syb_identity keyword in a delete statement on tables containing an IDENTITY column.

For example, to remove the row for which row_id equals 1, use:

delete sales_monthly
where syb_identity = 1

After you delete IDENTITY column rows, you may want to eliminate gaps in the table’s IDENTITY column numbering sequence.