SET INCREMENT
The SET INCREMENT
clause changes the increment of the identity column.
Renaming a Column: the TO Clause
Changing the Data Type of a Column: the TYPE Clause
Changing the Position of a Column: the POSITION Clause
The DROP DEFAULT and SET DEFAULT Clauses
The SET NOT NULL and DROP NOT NULL Clauses
The COMPUTED [BY] or GENERATED ALWAYS AS Clauses
SET INCREMENT
The SET INCREMENT
clause changes the increment of the 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. |
To stop replicating a table, use the DISABLE PUBLICATION
clause.To start replicating a table, use the ENABLE PUBLICATION
clause.
The change in publication status takes effect at commit.