Column Properties

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
  • 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.
Related reference
Index Properties
Trigger Properties
Foreign Key Properties
Check Constraint Properties
Partition Properties
Table Properties