|
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 | |||