Column Properties

• Name – specify a different table name.
• Datatype – change the datatype of the column, and depending on the datatype, the width and scale.
• Primary key – constrains the values in the indicated column or columns so that no two rows have the same value, and so that the value cannot be NULL.
• Allow nulls – specifies that Adaptive Server assign a null value if a user does not provide a value.
• Identity – indicates that the column has the IDENTITY property. Each table in a database can have one IDENTITY column with a datatype of either: exact numeric and a scale of 0, or of the integer datatypes, including signed or unsigned bigint, int, smallint, or tinyint.
• Object storage specifier – specifies whether a Java-SQL column is stored separately from the row (off row) or in storage allocated directly in the row (in row).
• Data compression – supported only on user tables, and in version 15.7 and later.

• Default – specify a default value that appears in the column if no value is entered for an insertion or update.
• Rule binding – bind rules to columns to provided criteria against which Adaptive Server checks data entered for an insertion or update.

See Binding Defaults and Rules to a Column.

Creates filters that data must pass through before the data can be inserted into a table. See Creating a Check Constraint.

You can grant and revoke permissions on a column or a table.

You can specify an encryption key for column encryption and optionally a default value when you do not have decrypt permission. See the Encrypted Columns Users Guide.