SAP ABAP Table SYB_SYSINDEXES (SYB: <dbname>..sysindexes)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_SYSINDEXES	Table Relationship Diagram
Short Description	SYB: <dbname>..sysindexes

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	NAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
2	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
3	INDID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
4	IPGTRIPS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
5	SEGMENT	☐			INT2	5	0
6	MAXROWSPERPAGE	☐			INT2	5	0
7	MINLEN	☐			INT2	5	0
8	MAXLEN	☐			INT2	5	0
9	MAXIROW	☐			INT2	5	0
10	KEYCNT	☐			INT2	5	0
11	SOID	☐			INT2	5	0
12	CSID	☐			INT2	5	0
13	FILL_FACTOR	☐			INT2	5	0
14	RES_PAGE_GAP	☐			INT2	5	0
15	EXP_ROWSIZE	☐			INT2	5	0
16	CRDATE	☐			STRG	0	0
17	PARTITIONTYPE	☐			STRG	0	0
18	CONDITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
19	IX_UNIQUE	☐			CHAR	1	0
20	IX_SORTEDDATA	☐			CHAR	1	0
21	IX_ISPRKEY	☐			CHAR	1	0
22	LARGEIO_ENABLED	☐			CHAR	1	0
23	MRU_ENABLED	☐			CHAR	1	0
24	IX_ISSUSPECT	☐			CHAR	1	0
25	IS_CLUSTERED	☐			CHAR	1	0
26	IX_TYPE	☐			CHAR	20	0
27	INDEX_COMPRESSION	☐			CHAR	20	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	703