Supported Objects

Go Up to Database Object Management

Database object management features are available across different supported database platforms. The table below indicates the supported object types by platform:

	DB2 LUW	DB2 z/OS	MySQL	ORCL	PSTGRS *	SQL SVR	SYB ASE	SYB IQ
Aliases	✓	✓					✓
Asymmetric Keys						✓
Audit Policies				✓
Certificates						✓
Chains				✓
Check Constraints	✓	✓		✓	✓	✓	✓
Clusters				✓
Database Links				✓
Database Triggers						✓
Databases		✓		✓		✓	✓
Defaults						✓	✓
Directories				✓
Domains					✓			✓
Events								✓
Exclusion Constraints					✓
Extended Procedures							✓
Foreign Keys	✓	✓	✓	✓	✓	✓	✓	✓
Full-text Catalogs						✓
Full-text Indexes						✓
Functions	✓	✓	✓	✓	✓	✓	✓	✓
Groups	✓			✓		✓	✓	✓
Indexes	✓	✓	✓	✓	✓	✓	✓	✓
Instance	✓			✓
Java Classes				✓
Java Resources				✓
Java Sources				✓
Jobs (Oracle)				✓
Job Queues				✓
Join Indexes								✓
Libraries				✓
Logins						✓	✓
Materialized Query Tables	✓
Materialized Views				✓
Materialized View Logs				✓
Outlines				✓
Package Bodies				✓
Packages	✓	✓		✓
Partition Functions						✓
Partition Schemes						✓
Plans		✓
Primary Keys	✓	✓	✓	✓	✓	✓	✓	✓
Procedures	✓	✓		✓		✓	✓	✓
Profiles				✓
Programs				✓
Recycle Bin				✓			✓
Resource Plans				✓
Roles				✓	✓	✓	✓
Rules					✓	✓	✓
Schedules				✓
Schema					✓	✓
Segments						✓	✓
Sequences	✓	✓		✓	✓
Structured Types	✓	✓
Symmetric Keys						✓
Synonyms		✓		✓		✓
System Indexes						✓	✓	✓
System Tables						✓	✓	✓
System Triggers								✓
Tables	✓	✓	✓	✓	✓	✓	✓	✓
Tablespaces	✓	✓		✓	✓
Triggers	✓	✓		✓	✓	✓	✓	✓
Type Bodies				✓
Types				✓	✓
Unified Auditing				✓
Unique Keys	✓	✓	✓	✓	✓	✓	✓	✓
User Datatypes	✓	✓				✓	✓
User Messages	✓					✓	✓
Users	✓	✓	✓	✓		✓	✓	✓
Views	✓	✓		✓	✓	✓	✓	✓