Enables users to insert values into or to update an IDENTITY or AUTOINCREMENT column.
= 'tablename'
Option not set.
Can be set only temporary (for a connection), for a user, or for the PUBLIC group. Takes effect immediately.
If you set a user level option for the current option,
the corresponding temporary option is also set. For details, see “Scope and duration of database options”.
When option is set, insert/update is enabled. A table name must be specified to identify the column to insert or update. If you are not the table owner, qualify the table name with the owner name.
To drop a table with an IDENTITY column, IDENTITY_INSERT must not be set to that table.
For example, if you use the table Employees to run explicit inserts:
SET TEMPORARY OPTION IDENTITY_INSERT = 'Employees'
To turn the option off, specify the equals sign and an empty string:
SET TEMPORARY OPTION IDENTITY_INSERT = ''
To illustrate the effect of user level options on temporary options (see note above), if you are connected to the database as DBA, and issue:
SET OPTION IDENTITY_INSERT = 'Customers'
the value for the option is set to Customers for the user DBA and temporary for the current connection. Other users who subsequently connect to the database as DBA find their option value for IDENTITY_INSERT is Customers also.
