Available object actions by DBMS

From DBArtisan
Jump to: navigation, search

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