X$Attrib

---

The X$Attrib system table is associated with the file ATTRIB.DDF. X$Attrib contains information about the column attributes of each column in the database; there is an entry for each column attribute you define. The structure of X$Attrib is as follows:

 
Table C-9 X$Attrib System Table Structure

Column Name	Type	Size	Case Insensitive	Description
Xa$Id	USMALLINT	2	N/A	Corresponds to Xe$Id in X$Field.
Xa$Type	CHAR	1	No	D for default
Xa$ASize	USMALLINT	2	N/A	Length of text in Xa$Attrib.
Xa$Attrs	LONGVARCHAR (NOTE)	<=2048	N/A	Text that defines the column attribute.

When you define multiple attributes for a single column, the X$Attrib system table contains multiple entries for that column ID - one for each attribute you define. If you do not define column attributes for a particular column, that column has no entry in the X$Attrib table. The text in the Xa$Attrs column appears exactly as you define it with Pervasive.SQL. One index is defined for the X$Attrib table, as follows:

 
Table C-10 X$Attrib System Table Index Definitions

Index Number	Segment Number	Column Name	Duplicates	Case Insensitive	Segmented
0	0	Xa$Id	No	N/A	Yes
0	1	Xa$Type	No	No	No

Index Number corresponds to the value stored in the Xi$Number column in the X$Index system table. Segment Number corresponds to the value stored in the Xi$Part column in the X$Index system table.