Update IDENTITY Columns

You can use the syb_identity keyword, qualified by the table name, where necessary, to update an IDENTITY column.

For example, this update statement finds the row in which the IDENTITY column equals 1 and changes the name of the store to “Barney’s”:

update stores_cal
set stor_name = "Barney’s"
where syb_identity = 1