sysattributes

Applies to all databases. System attributes define properties of objects such as databases, tables, indexes, users, logins, and procedures. sysattributes contains one row for each of an object’s attribute definitions (configured by various system procedures). master..sysattributes defines the complete set of valid attribute values and classes for the SAP ASE server as a whole. It also stores attribute definitions for server-wide objects, such as databases and logins.

Use only system procedures to access sysattributes. The permissions required for modifying sysattributes depend on the system procedure you use.

Columns

The columns for sysattributes are:

Name	Datatype	Description
`class`	`smallint`	The attribute class ID. This describes the category of the attribute. In `master..sysattributes`, the special class 0 identifies all valid classes of attributes for the SAP ASE server.
`attribute`	`smallint`	The attribute ID, this column specifies a default decrypt on an encrypted column with a value of 1 (DECRYPT-DEFAULT_ID) for objects with a type of `EC` and a class of 25.
`object_type`	`char(2)`	A one- or two-letter character ID that defines the type of object to associate with the attribute.
`object_cinfo`	`varchar(255) null`	A string identifier for the object (for example, the name of an application). This field is not used by all attributes.
`object_cinfo2`	`varchar(255) null`	A string identifier for the object (for example, the name of an application) in a SDC environment. This field is not used by all attributes.
`object`	`int null`	The object identifier. This may be an object ID, user ID, decrypt default ID, or database ID, depending on the type of object. If the object is a part of a table (for example, an index), this column contains the object ID of the associated table.
`object_info1`, `object_info2`, `object_info3`	`int null`	Defines additional information required to identify the object. This field is not used by all attributes. The contents of this field depend on the attribute that is defined. `object_info_1` – includes the table ID for a table whose encrypted column defines the decrypt default. `object_info2` – specifies the `colid` of the encrypted column that includes the decrypt default.
`int_value`	`int null`	An integer value for the attribute (for example, the display level of a user).
`char_value`	`varchar(768) null`	A character value for the attribute (for example, a cache name).
`text_value`	`text null`	A text value for the attribute.
`image_value`	`image null`	An image value for the attribute.
`comments`	`varchar(255) null`	Comments or additional information about the attribute definition.
`object_datetime`	`null`	`datetime` value for the attribute. Its use depends on the module using the attribute, but it typically refers to the date and time the attribute was created.

The relevant values most frequently used in object_type are:

D – Database
I – Index
L – Login
LR – Login Profile
P – Proc
T – Table
U – User
AP – Application
DC – Dump Condition
EL – External Login (OMNI)
OD – Object Definition (OMNI)
TC – Transaction Coordination (ASTC)
TG – Temporary Database Group (multi tempdb)
TP – Text Page (OMNI)
QP – Query Plans (abstract plans)
UR – User Role
GR – Group Role
LG – Login (for MTDB binding)
EG – Engine Group
PS – Password Security
SP – Keypair Regeneration Period

These values provide additional information for sysattributes, and are not for use as standalone values. For this reason, use these values only in conjunction with the class ID.

Indexes

Unique clustered index on class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo.
Nonclustered index on object_type, object, object_info1, object_info2, object_info3, object_cinfo.