sp_iq_reset_identity Procedure Example

Use the example as a reference for sp_iq_reset_identity usage.

Example 1

The following example creates an Identity column with a starting seed of 50:
CREATE TABLE mytable(c1 INT identity)
call sp_iq_reset_identity('mytable', 'dba', 50)
Parent topic: sp_iq_reset_identity Procedure