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
Last updated: February 23, 2017