Available object actions by DBMS

From RapidSQL
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 IITB/FBD * 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 Certificate

Bind Package

Bind To Temporary Database

Build

Build Query


Change Access Status

Change Category


Change Password

Change Status


Check Tables


Checkpoint


Checksum Tables

Coalesce

Compile

Convert Tables

Copy Object Names

Copy Schema


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


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)


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


Load Java

Lock

Lower High Water Mark


Move Log

Move Table

Next Used Filegroup

Object Properties

Optimize Tables

Place

Population status

Purge Recycle Bin

Purge Recycle Bin Entry

Quiesce


Reassign By Category

Rebalance


Rebind Packages

Rebind Plans

Rebuild (Full-text Catalogs)

Rebuild Index

Rebuild Outlines

Rebuild Table

Recompile


Refresh Materialized View

Refresh Table


Rename

Reorganize /Reorg

Repair Tables

Report


Restart (Object Action)

Restart Sequence(s)

Resynchronize

Run Job (Oracle Jobs)

Run Job (job queues)

Role Activation


Run Job (job queues)


Schema (Object Action)

Select * From

Set Default

Set Integrity

Set Online/Offline

Set Statistics

Set UNDO

Shrink

Start Database


Stop Database

Stop Job


Switch Online


Transfer Ownership

Truncate

Unbind From Temporary Database


Update Statistics