Object actions

From DBArtisan
Jump to: navigation, search

Go Up to Database Object Management

In addition to letting you create and perform basic editing on various object types, there are a number of actions can be applied to objects. While object action support differs by DBMS platform, they are most commonly implementations of:

  • ALTER OBJECT TYPE clauses/options not typically available from object editors, such as REBUILD INDEX and RENAME
  • Other SQL commands such as TRUNCATE, REORG, and LOCK
  • System procedures and other available utilities

Most object actions are implemented as multi-panel wizards that guide you through the action. For an introduction to invoking object actions and working through the panels, see Overview of object actions/operations execution.

For a listing of available actions and access to detailed instructions, see Available object actions by DBMS.