Available object actions by DBMS

Go Up to [[Object actions{{#if:||{{{2}}}}}]]

The following table 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						✓		<l s="dbartisan"/>
Backup						✓	✓	<l e="dbartisan"/>
Backup Certificate						✓
Bind Package		✓
Bind To Temporary Database							✓
Build		✓
Build Query	✓	✓	✓	✓		✓	✓	<l s="dbartisan"/>
Cancel Thread		✓						<l e="dbartisan"/>
Change Access Status				✓
Change Category				✓				<l s="dbartisan"/>
Change Job's Owner						✓		<l e="dbartisan"/>
Change Password				✓		✓
Change Status				✓		✓	✓	<l s="dbartisan"/>
Check Data		✓
Check Disk Group				✓
Check Index		✓						<l e="dbartisan"/>
Check Tables			✓
Checkpoint						✓	✓
Checksum Tables			✓
Coalesce				✓
Compile				✓
Convert Tables			✓
Copy Object Names	✓	✓		✓		✓	✓
Copy Schema	✓							<l s="dbartisan"/>
Copy to Copy		✓						<l e="dbartisan"/>
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						✓	✓	<l s="dbartisan"/>
Disconnect ASM Connection				✓				<l e="dbartisan"/>
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)				✓				<l s="dbartisan"/>
Enable/Disable Job (SQL Agent Job)						✓		<l e="dbartisan"/>
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		✓
Hide Text							✓
Import Data From File	✓	✓	✓	✓		✓	✓	<l s="dbartisan"/>
Kill	✓		✓	✓		✓	✓	<l e="dbartisan"/>
Load Java				✓
Lock	✓	✓
Lower High Water Mark	✓							<l s="dbartisan"/>
Manage ASM Connection				✓
Merge Copy		✓
Migrate	✓	✓		✓		✓	✓
Mirror							✓
Modify Recovery		✓
Modify Statistics	✓					✓	✓
Mount Disk Group			✓					<l e="dbartisan"/>
Move Log							✓
Move Table	✓
Next Used Filegroup						✓
Object Properties								✓ <l s="dbartisan"/>
Open (Logs and Error logs)						✓
Open Control Files				✓				<l e="dbartisan"/>
Optimize Tables			✓
Place						✓	✓
Population status						✓
Purge Recycle Bin				✓
Purge Recycle Bin Entry				✓
Quiesce	✓							<l s="dbartisan"/>
Quiesce Tablespaces		✓						<l e="dbartisan"/>
Reassign By Category				✓
Rebalance	✓							<l s="dbartisan"/>
Rebalance Disk Group				✓				<l e="dbartisan"/>
Rebind Packages	✓	✓
Rebind Plans	✓	✓
Rebuild (Full-text Catalogs)						✓
Rebuild Index		✓		✓		✓
Rebuild Outlines				✓
Rebuild Table			✓
Recompile						✓	✓	<l s="dbartisan"/>
Recover		✓
Recover Abort		✓
Recover Commit		✓
Redistribute	✓
Refit							✓	<l e="dbartisan"/>
Refresh Materialized View					✓
Refresh Table	✓							<l s="dbartisan"/>
Reinitialize							✓	<l e="dbartisan"/>
Rename	✓	✓	✓	✓		✓	✓
Reorganize /Reorg	✓	✓		✓		✓	✓
Repair Tables			✓
Report	✓	✓	✓	✓		✓	✓	<l s="dbartisan"/>
Resize							✓	<l e="dbartisan"/>
Restart (Object Action)	✓
Restart Sequence(s)						✓
Resynchronize		✓
Run Job (Oracle Jobs)				✓
Run Job (job queues)	✓
Role Activation				✓			✓	<l s="dbartisan"/>
Rotate Log					✓			<l e="dbartisan"/>
Run Job (job queues)				✓				<l s="dbartisan"/>
Runstats Index		✓
Runstats Tablespace		✓						<l e="dbartisan"/>
Schema (Object Action)	✓	✓	✓	✓		✓	✓
Select * From	✓	✓	✓	✓		✓	✓
Set Default				✓
Set Integrity	✓	✓
Set Online/Offline							✓
Set UNDO				✓
Shrink				✓		✓
Start Database		✓						<l s="dbartisan"/>
Start/Stop Job (SQL Agent Job)						✓		<l e="dbartisan"/>
Stop Database		✓
Stop Job				✓				<l s="dbartisan"/>
Switch Logfile				✓				<l e="dbartisan"/>
Switch Online	✓							<l s="dbartisan"/>
Take Checkpoint				✓				<l e="dbartisan"/>
Transfer Ownership	✓
Truncate	✓	✓	✓	✓		✓	✓
Unbind From Temporary Database							✓	<l s="dbartisan"/>
Undrop Disk				✓
Unmirror							✓	<l e="dbartisan"/>
Update Statistics	✓					✓	✓	<l s="dbartisan"/>
View Contents						✓
View Job History						✓		<l e="dbartisan"/>