Available object actions by DBMS

Go Up to Object actions

The table below lists the available object actions by DBMS platform.

	DB2 LUW	DB2 z/OS	MySQL	ORCL	PSTGRS *	SQL SVR	SYB ASE	SYB IQ
Add or Modify Check Constraint	✓	✓		✓		✓	✓
Add/Modify Login Trigger							✓
Add Private Key						✓
Allocate Extent				✓		✓
Analyze				✓		✓
Analyze Tables			✓
Attach Database						✓
Backup						✓	✓
Backup Certificate						✓
Bind Package		✓
Bind To Temporary Database							✓
Build		✓
Build Query	✓	✓	✓	✓		✓	✓
Cancel Thread		✓
Change Access Status				✓
Change Category				✓
Change Job's Owner						✓
Change Password				✓		✓
Change Status				✓		✓	✓
Check Data		✓
Check Disk Group				✓
Check Index		✓
Check Tables			✓
Checkpoint						✓	✓
Checksum Tables			✓
Coalesce				✓
Compile				✓
Convert Tables			✓
Copy Object Names	✓	✓		✓		✓	✓
Copy Schema	✓
Copy to Copy		✓
Create Alias	✓	✓
Create Clone		✓
Create Insert Statements	✓	✓	✓	✓		✓	✓
Create Like	✓	✓	✓	✓		✓	✓
Create Synonym	✓	✓		✓
Create View	✓	✓		✓		✓	✓
DBCC						✓	✓
Deallocate Unused Space				✓
Delete Statistics							✓
Describe	✓
Detach Database						✓
Disable Index						✓
Disable Job				✓
Disable Keys			✓
Disable/Enable Triggers						✓	✓
Disconnect ASM Connection				✓
Drop	✓	✓	✓	✓		✓	✓	✓
Drop Automatic Storage Path(s)	✓
Drop By Category				✓
Drop Clone		✓
Drop Java				✓
Drop Login Trigger							✓
Drop Materialized Query Table	✓
Drop Unused				✓
Drop Unused				✓
Backup Certificate						✓
Enable Job (Job Queue)				✓
Enable Keys			✓
Enable Recycle Bin				✓
Enable/Disable (Oracle Jobs)				✓
Enable/Disable Job (SQL Agent Job)						✓
Estimate Size							✓
Exchange Data With Clone		✓
Execute				✓			✓
Extract	✓	✓	✓	✓		✓	✓	✓
Extract Data as XML				✓		✓
Flashback Recycle Bin Entry				✓
Flashback Table				✓
Flush Cache	✓
Flush Tables			✓
Free (Packages)		✓
Free Plan		✓
Generate Package/Procedure/Statement	✓	✓		✓		✓	✓
Hide Text							✓
Import Data From File	✓	✓	✓	✓		✓	✓
Kill	✓		✓	✓		✓	✓
Load Java				✓
Lock	✓	✓
Lower High Water Mark	✓
Manage ASM Connection				✓
Merge Copy		✓
Migrate	✓	✓		✓		✓	✓
Mirror							✓
Modify Recovery		✓
Modify Statistics	✓					✓	✓
Mount Disk Group			✓
Move Log							✓
Move Table	✓
Next Used Filegroup						✓
Object Properties								✓
Open (Logs and Error logs)						✓
Open Control Files				✓
Optimize Tables			✓
Place						✓	✓
Population status						✓
Purge Recycle Bin				✓
Purge Recycle Bin Entry				✓
Quiesce	✓
Quiesce Tablespaces		✓
Reassign By Category				✓
Rebalance	✓
Rebalance Disk Group				✓
Rebind Packages	✓	✓
Rebind Plans	✓	✓
Rebuild (Full-text Catalogs)						✓
Rebuild Index		✓		✓		✓
Rebuild Outlines				✓
Rebuild Table			✓
Recompile						✓	✓
Recover		✓
Recover Abort		✓
Recover Commit		✓
Redistribute	✓
Refit							✓
Refresh Materialized View					✓
Refresh Table	✓
Reinitialize							✓
Rename	✓	✓	✓	✓		✓	✓
Reorganize /Reorg	✓	✓		✓		✓	✓
Repair Tables			✓
Report	✓	✓	✓	✓		✓	✓
Resize							✓
Restart (Object Action)	✓
Restart Sequence(s)						✓
Resynchronize		✓
Run Job (Oracle Jobs)				✓
Run Job (job queues)	✓
Role Activation				✓			✓
Rotate Log					✓
Run Job (job queues)				✓
Runstats Index		✓
Runstats Tablespace		✓
Schema (Object Action)	✓	✓	✓	✓		✓	✓
Select * From	✓	✓	✓	✓		✓	✓
Set Default				✓
Set Integrity	✓	✓
Set Online/Offline							✓
Set UNDO				✓
Shrink				✓		✓
Start Database		✓
Start/Stop Job (SQL Agent Job)						✓
Stop Database		✓
Stop Job				✓
Switch Logfile				✓
Switch Online	✓
Take Checkpoint				✓
Transfer Ownership	✓
Truncate	✓	✓	✓	✓		✓	✓
Unbind From Temporary Database							✓
Undrop Disk				✓
Unmirror							✓
Update Statistics	✓					✓	✓
View Contents						✓
View Job History						✓