Revision as of 15:59, 13 March 2009

SYSINDEXINFO

SQL Applications

Description of a table’s indices and statistics

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.

Column	Data Type	Width	Description
TABLE_CAT	C	30	Table catalog
TABLE_SCHEM	C	30	Table schema
TABLE_NAME	C	30	Table name
NON_UNIQUE	L	1	Can index values be non-unique?
INDEX_QUALIFIER	C	30	Index catalog
INDEX_NAME	C	30	Index name
TYPE	N	2	Index type
ORDINAL_POSITION	N	3	Column sequence number within index
COLUMN_NAME	C	30	Column name
ASC_OR_DESC	C	1	Column sort sequence, "A" is ascending, "D" is descending
CARDINALITY	N	10	The number of rows in the table or the number of unique values in the index, depending on the index type
PAGES	N	2	The number of pages used for the table or the number of pages used for the current index, depending on the index type
FILTER_CONDITION	C	30	Filter condition

EXEC SQL
SELECT *
FROM sysindexinfo;

Recital Database Server, Recital Mirage Server, Recital Terminal Developer

Revision as of 12:14, 13 March 2009 (view source) Yvonnemilne (Talk \| contribs)		Revision as of 15:59, 13 March 2009 (view source) Yvonnemilne (Talk \| contribs) Newer edit →
Line 11:		Line 11:

	==See Also==		==See Also==
−	[[DATA TYPES]], [[SQL SELECT\|SELECT]], [[SYSTEM TABLES]]	+	[[SQL Data Types\|DATA TYPES]], [[SQL SELECT\|SELECT]], [[SQL System Tables\|SYSTEM TABLES]]