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
Alerts						✓	✓
Aliases	✓	✓					✓
Asymmetric Keys						✓
Audit Policies				✓
Bufferpools	✓	✓
Certificates						✓
Chains				✓
Check Constraints	✓	✓		✓	✓	✓	✓
Clusters				✓
Control Files				✓
Database Devices						✓	✓
Database Links				✓
Database Triggers						✓
Databases		✓		✓		✓	✓
Data Caches							✓
DBRM		✓
Defaults						✓	✓
Directories				✓
Disk Groups				✓
Domains					✓			✓
Dump and Backup Devices						✓
Error Logs						✓
Event Monitors	✓
Events								✓
Exclusion Constraints					✓
Extended Procedures							✓
Foreign Keys	✓	✓	✓	✓	✓	✓	✓	✓
Full-text Catalogs						✓
Full-text Indexes						✓
Functions	✓	✓	✓	✓	✓	✓	✓	✓
Groups	✓			✓		✓	✓	✓
Image Copies		✓
Indexes	✓	✓	✓	✓	✓	✓	✓	✓
Instance	✓			✓
Java Classes				✓
Java Resources				✓
Java Sources				✓
Jobs (Oracle)				✓
Jobs (SQL Server)						✓
Job Queues				✓
Join Indexes								✓
Libraries				✓
Linked Servers						✓
Logins						✓	✓
Logs (SQL Server Agent)						✓
Materialized Query Tables	✓
Materialized Views				✓
Materialized View Logs				✓
Nodegroups	✓
Operators						✓
Outlines				✓
Package Bodies				✓
Packages	✓	✓		✓
Partition Functions						✓
Partition Schemes						✓
Plans		✓
Primary Keys	✓	✓	✓	✓	✓	✓	✓	✓
Procedures	✓	✓		✓		✓	✓	✓
Profiles				✓
Programs				✓
Recycle Bin				✓			✓
Redo Log Groups				✓
Remote Servers						✓	✓
Resource Plans				✓
Roles				✓	✓	✓	✓
Rollback Segments				✓
Rules					✓	✓	✓
Schedules				✓
Schema					✓	✓
Segments						✓	✓
Sequences	✓	✓		✓	✓
Server Roles						✓
Server Triggers						✓
Stogroups		✓
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	✓	✓		✓	✓	✓	✓	✓