You can use the syb_identity keyword in a delete statement on tables containing an IDENTITY column. For example, this statement removes the row for which row_id equals 1:
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. See “Renumber the table’s IDENTITY columns with bcp”.
