SAP ABAP Table SYB_SYSOBJECTS (SYB: <dbname>..sysobjects)

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_SYSOBJECTS	Table Relationship Diagram
Short Description	SYB: <dbname>..sysobjects

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	UID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
4	USER_NAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
5	TYPE	☐			STRG	0	0
6	SUSPECT_INDEXES	☐			CHAR	1	0
7	SCHEMACNT	☐			INT2	5	0
8	INDEXDEL	☐			INT2	5	0
9	LOCKINGSCHEME	☐			STRG	0	0
10	HAS_PRKEY	☐			CHAR	1	0
11	CRDATE	☐			STRG	0	0
12	DELTRIG	☐			INT4	10	0
13	INSTRIG	☐			INT4	10	0
14	UPDTRIG	☐			INT4	10	0
15	CR_LOGINNAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
16	PARTITIONTYPE	☐			STRG	0	0
17	CONDITIONID	☐			INT4	10	0
18	MAXROWSPERPAGE	☐			INT2	5	0
19	MINLEN	☐			INT2	5	0
20	MAXLEN	☐			INT2	5	0
21	EXP_ROWSIZE	☐			INT2	5	0
22	DELTRIG_CNT	☐			INT2	5	0
23	INSTRIG_CNT	☐			INT2	5	0
24	UPDTRIG_CNT	☐			INT2	5	0
25	LOB_COMPRESSION	☐			CHAR	20	0
26	DATA_COMPRESSION	☐			CHAR	20	0
27	INDEX_COMPRESSION	☐			CHAR	20	0
28	MATERIALIZED	☐			CHAR	10	0
29	DEALLOC_1ST_TXTPG	☐			CHAR	10	0

History

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