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.
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 = ''
