DROP IDENTITY
The DROP IDENTITY
clause will change an identity column to a regular column.
Note
|
It is not possible to change a regular column to an identity column. |
DROP IDENTITY
The DROP IDENTITY
clause will change an identity column to a regular column.
Note
|
It is not possible to change a regular column to an identity column. |
Using the ALTER SQL SECURITY
or DROP SQL SECURITY
clauses, it is possible to change or drop the SQL Security property of a table.After dropping SQL Security, the default value of the database is applied at runtime.
Note
|
If the SQL Security property is changed for a table, triggers that do not have an explicit SQL Security property will not see the effect of the change until the next time the trigger is loaded into the metadata cache. |