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.

Related tasks
Renumbering the Table IDENTITY Columns with bcp