DICTIONARY.STATISTICS

The following table lists the columns that appear in the result table for the DICTIONARY.STATISTICS table.

Note: Null indicates either a null or a missing value.

Column Name	Column Number	Data Type	Description
TABLE_CAT	1	NVARCHAR1	TKTS catalog name.
TABLE_SCHEM	2	NVARCHAR	Schema name of the table to which the statistic or index applies. Null if not applicable to the data source. If a driver supports schemas for some tables but not for others, such as when the driver retrieves data from different DBMSs, it returns an empty string ("") for those tables that do not have schemas.
TABLE_NAME	3	NVARCHAR not null	Name of the table to which the statistic or index applies.
NON_UNIQUE	4	signed INTEGER	Indicates whether the index prohibits duplicate values: TKTS_TRUE if the index values can be non-unique. TKTS_FALSE if the index values must be unique. Null is returned if TYPE is TKTS_TABLE_STAT.
INDEX_QUALIFIER	5	NVARCHAR	The identifier that is used to qualify the index name doing a DROP INDEX. Null is returned if an index qualifier is not supported by the data source or if TYPE is TKTS_TABLE_STAT. If a non-null value is returned in this column, it must be used to qualify the index name on a DROP INDEX statement; otherwise, the TABLE_SCHEM should be used to qualify the index name.
INDEX_NAME	6	NVARCHAR	Index name. Null is returned if TYPE is TKTS_TABLE_STAT.
TYPE	7	signed INTEGER1	Type of information being returned: TKTS_TABLE_STAT indicates a statistic for the table in the CARDINALITY or PAGES column. TKTS_INDEX_BTREE indicates a B-Tree index. TKTS_INDEX_CLUSTERED indicates a clustered index. TKTS_INDEX_CONTENT indicates a content index. TKTS_INDEX_HASHED indicates a hashed index. TKTS_INDEX_OTHER indicates another type of index.
ORDINAL_POSITION	8	signed INTEGER	Column sequence number in index starting with 1. Null is returned if TYPE is TKTS_TABLE_STAT.
COLUMN_NAME	9	NVARCHAR	Column name. If the column is based on an expression, such as SALARY + BENEFITS, the expression is returned; if the expression cannot be determined, an empty string is returned. Null is returned if TYPE is TKTS_TABLE_STAT.
ASC_OR_DESC	10	CHAR(1)	Sort sequence for the column: A for ascending; D for descending. Null is returned if column sort sequence is not supported by the data source or if TYPE is TKTS_TABLE_STAT.
CARDINALITY	11	signed BIGINT	Cardinality of table or index. Number of rows in table if TYPE is TKTS_TABLE_STAT. Number of unique values in the index if TYPE is not TKTS_TABLE_STAT. Null if the value is not available from the data source.
PAGES	12	signed INTEGER	Number of pages used to store the index or table. Number of pages for the table if TYPE is TKTS_TABLE_STAT. Number of pages for the index if TYPE is not TKTS_TABLE_STAT. Null if the value is not available from the data source or if not applicable to the data source.
FILTER_CONDITION	13	NVARCHAR	If the index is a filtered index, this is the filter condition, such as SALARY > 30000. If the filter condition cannot be determined, the value is an empty string. Null if the index is not a filtered index, if it cannot be determined whether the index is a filtered index, or if TYPE is TKTS_TABLE_STAT.
AVG_FANOUT2	14	DOUBLE	The average fan-out of internal nodes for an index. Valid for TKTS_INDEX_* TYPE records. Null if not known or available.
MAX_FANOUT2	15	unsigned INTEGER	The maximum fan-out of internal nodes for an index. Valid for TKTS_INDEX_* TYPE records. Null if not known or available.
MIN_FANOUT2	16	unsigned INTEGER	The minimum fan-out of internal nodes for an index. Valid for TKTS_INDEX_* TYPE records. Null if not known or available.
INDEX_LEVELS2	17	unsigned INTEGER	The number of levels in an index. Valid for TKTS_INDEX_* TYPE records. Null if not known or available.
LEAF_LEVEL_BLOCKS2	18	unsigned INTEGER	The number of blocks at the leaf level of an index. Valid for TKTS_INDEX_* TYPE records. Null if not known or available.
LOCAL2	19	NVARCHAR	Whether a table is local or must be accessed over a network. Valid for TKTS_TABLE_STAT TYPE records. Values YES, NO or Null if unknown.
PARTITION_SCHEME2	20	unsigned INTEGER	Whether the table is partitioned and, if so, does it use a round-robin, hash- or range-partitioning scheme. Valid for TKTS_TABLE_STAT TYPE records. TKTS_PARTITION_NONE indicates the table is not partitioned. TKTS_PARTITION_ROUND_ROBIN indicates a round-robin partitioning scheme. TKTS_PARTITION_HASH indicates a hash partitioning scheme. TKTS_PARTITION_RANGE indicates a range partitioning scheme. Null if not known or available.
FRAGMENTATION2	21	unsigned INTEGER	If the data is distributed, indicates whether it uses vertical fragmentation, horizontal fragmentation, derived fragmentation, or a hybrid fragmentation. Valid for TKTS_TABLE_STAT TYPE records. TKTS_FRAG_NONE indicates the data is not distributed. TKTS_FRAG_VERTICAL indicates vertical fragmentation. TKTS_FRAG_HORIZONTAL indicates horizontal fragmentation. TKTS_FRAG_DERIVED indicates derived fragmentation. TKTS_FRAG_HYBRID uses hybrid fragmentation. Null if not known or available.
LABEL2	22	NVARCHAR (max 256 characters)	Label associated with the table. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
APPLICATION_TYPE2	23	NVARCHAR (max 8 characters)	SAS application-specific type associated with the table. The value of this type field is created, stored, and retrieved by some SAS applications. The meaning of the value is specific to the application that created it. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
PROTECTED2	24	signed INTEGER	Indicates whether table is password protected. Valid for TKTS_TABLE_STAT TYPE records. TKTS_PROTECTION_NONE indicates table is not password protected. TKTS_PROTECTION_READ indicates table is Read protected. TKTS_PROTECTION_WRITE indicates table is Write protected. TKTS_PROTECTION_ALTER indicates table is alter protected. TKTS_PROTECTION_ENCRYPTED indicates table is encrypted. Null if not known or available.
COMPRESS2	25	NVARCHAR (max 8 characters)	Indicates whether the records in the table are compressed. Valid for TKTS_TABLE_STAT TYPE records. NO Indicates records are uncompressed. YES\|CHAR indicates RLE(Run Length Encoding) used to compress records. BINARY indicates RDC(Ross Data Compression) used to compress records. Null if not known or available.
CHAR_CEI2	26	unsigned INTEGER	Encoding value used for the table. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
DELETED_ROWS2	27	signed BIGINT	Number of deleted rows in the table. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
DATE_CREATED2	28	DOUBLE	Date the table was created. Value is a DATETIME that is defined by SAS. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
DATE_MODIFIED2	29	DOUBLE	Date the table was last modified. Value is a DATETIME that is defined by SAS. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
TABLE_ATTRIBUTES2	30	signed INTEGER	Attributes that apply to the table. This column represents a set of flags to convey specific attributes. A value of 0 for any flag indicates either a False or unknown condition. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
ROW_LENGTH2	31	signed BIGINT	Length of the rows in the table on disk. Valid for TKTS_TABLE_STAT TYPE records. Null if not known or available.
1Value cannot be a null or missing value
2Optional-not defined in ODBC