Chapter 1: System Tables

sysattributes

All databases

Description

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 Adaptive 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 Adaptive Server.
attribute	smallint	The attribute ID.
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	int null	The object identifier. This may be an object ID, user 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.
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.

Table 1-1 lists the relevant values most frequently used in object_type. 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.

**Table 1-1: Valid values for the *object_type* column of sysattributes**
Value	Description
D	Database
I	Index
L	Login
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 (mult 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

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.

View this book as PDF