Use the Columns Properties window to change permissions, create check constraints,
specify encryption keys, and bind rules and defaults to columns.
Click the Name field of the column, then click the drop-down arrow and select
Properties.
| Pages |
Properties |
|---|
| General |
- 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 SAP ASE 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.
|
| Rules and Defaults |
- 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 is SAP ASE checks data entered for an insertion or
update.
|
| Check Constraints |
Creates filters that data must pass through before the data can be
inserted into a table. |
| Permissions |
You can grant and revoke permissions on a column or a table. |
| Encryption |
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. |