Databases

From RapidSQL
Jump to: navigation, search

Go Up to Supported Objects

Databases are a collection of tables, or a collection of index spaces and tablespaces. The goals of a database system are straightforward but challenging. In general, a database aims to manage large amounts of data in a multi-user environment. It should achieve high performance while letting many users access the same information concurrently without compromising data integrity. A database also must protect against unauthorized access and provide reliable solutions for failure recovery.

Creating and editing

Note: Objects of this type cannot be created or edited against PostgreSQL datasources.

DBMS platform availability and object actions/operations supported

The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.

DB2 LUW DB2 z/OS PSTGRS * SQL SVR SYB ASE

Attach Database

Checkpoint

Copy Schema

DBCC

Detach Database

Drop

Drop Automatic Storage Path(s)

Extract

Hide Text

Migrate

Move Log

Quiesce (Database)

Rename

Report

Resynchronize

Set Online/Offline

Shrink

Start Database

Stop Database

Unquiesce

Update Statistics

DBMS-specific information