Sybase AS Enterprise extended attributes

Chapter 14 DBMS-Specific Features

The following extended attributes are defined by default in the Sybase AS Enterprise DBMS.

The following extended attributes are available on the Sybase tab:

Name	Internal Code	Description
Store Java-SQL column in row	InRow	Specifies whether a Java-SQL column is stored separate from the row (set to False) or in storage allocated directly in the row (set to True).
Computed column is materialized	Materialized	Specifies that the computed column is materialized.
Encryption Key	EncryptionKey	Specifies an encryption key name.

The following extended attributes are available for extended objects with a stereotype of Encryption Key, on the Detail tab (version 12.5.3a only):

Name	Internal Code	Description
Algorithm	Algorithm	Advanced Encryption Standard (AES) is the only algorithm supported.
Default encryption key	Default	Allows the System Security Officer to create a default key for use on all encrypted columns which do not have a keyname specified in create table or alter table. This is a database specific default key for use with tables in the same database. The default key is stored in the database sysencryptkeys table, the same as non-default keys.
Initialization vector	InitVector	Omits the use of an initialization vector when encrypting. This makes the column suitable for supporting an index. When an initialization vector is used by the encryption algorithm, the ciphertext of two identical pieces of plaintext will be different, which would prevent the cryptanalyst from detecting patterns of data but would render the data on disk useless for indexing or matching without decryption.
Key length	KeyLength	Size in bits of the key to be created.For AES valid key lengths are 128, 192 and 256 bits.
Padding of datatypes	Pad	To use padding of datatypes whose length is less than one block. Padding can be used instead of an initialization vector to randomize the ciphertext. It is only suitable for columns whose plaintext length is less than half the block length. For the default AES algorithm the block length is 16 bytes.

The following extended attributes are available on the Sybase tab:

Name	Internal Code	Description
Key index is descending	DescKey	Specifies if the index created for a constraint is to be created in descending order for each column.

The following extended attributes are available on the Encryption tab (version 12.5.3a only):

Name	Internal Code	Description
Encryption password	EncryptionPassword	Global encryption password.

The following extended attributes are available on the Sybase tab:

Name	Internal Code	Description
Number of partitions	ExtTablePartition	Specifies the number of partitions for a table.