New SYSIQOBJECTS view

A new view, dbo.SYSIQOBJECTS, provides database administrators with a single source of information about all IQ objects. Table 1-2 lists the system tables from which the SYSIQOBJECTS information is derived and the values of the type column, which identifies each object type.

**Table 1-2: SYSIQOBJECTS.type values**
Type of object	Value of type column	Source system table
System table	S	SYS.SYSTABLE SYS.SYSIQTABLE
User table	U	SYS.SYSTABLE SYS.SYSIQTABLE
View	V	SYS.SYSTABLE SYS.SYSIQTABLE
Procedure	P	SYS.SYSPROCEDURE
Trigger (not currently supported by IQ)	TR	SYS.SYSTRIGGER SYS.SYSTABLE
Event	EV	SYS.SYSEVENT
Join index	JI	SYS.SYSIQJOININDEX
Constraint	CO	SYS.SYSCONSTRAINT
Domain (sysdomain)	SD	SYS.SYSDOMAIN
Domain (sysusertype)	UD	SYS.SYSUSERTYPE
Column	CL	SYS.SYSCOLUMN
Index	IX	SYS.SYSINDEX

The SYSIQOBJECTS column crdate contains the creation date of objects for which IQ has stored the creation date.