Difference between revisions of "SYSINDEXINFO"

Latest revision as of 16:48, 22 December 2009

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

SELECT * FROM sysindexinfo

Recital, Recital Server

@@ Line 1: / Line 1: @@
-=SYSINDEXINFO=
-==Class==
-SQL Applications
 ==Purpose==
 Description of a table’s indices and statistics
@@ Line 11: / Line 4: @@
 ==See Also==
-[[DATA TYPES]], [[SQL SELECT|SELECT]], [[SYSTEM TABLES]]
+[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]]
@@ Line 52: / Line 45: @@
 ==Example==
 <code lang="recital">
-EXEC SQL
+SELECT * FROM sysindexinfo
-SELECT *
-FROM sysindexinfo;
 </code>
 ==Products==
-Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+Recital, Recital Server
 [[Category:Documentation]]
 [[Category:SQL]]
 [[Category:System Tables]]