Character Columns
Setting a
Domain-based Columns
GENERATED ALWAYS
GENERATED BY DEFAULT
START WITH
INCREMENT
Computed Columns
Defining an Array Column
The
PRIMARY KEY
NULL
Foreign Key Actions
CHECK
NOT NULL
SQL SECURITY
Replication Management
Who Can Create a Table
CREATE TABLE
Restrictions on GTTs
Examples of Global Temporary Tables
External Table Example
Version Count Increments
Renaming a Column: the
Changing the Data Type of a Column: the
Changing the Position of a Column: the
Identity Type
RESTART
SET INCREMENT
DROP IDENTITY
Changing SQL Security
Attributes that Cannot Be Altered
Who Can Alter a Table?
Examples Using
Who Can Drop a Table?
Example of
The SET INCREMENT clause changes the increment of the identity column.
The DROP IDENTITY clause will change an identity column to a regular column.
It is not possible to change a regular column to an identity column.