Change Schema

From RapidSQL
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you generate and submit an ALTER objecttype objectname SET SCHEMA newobjectname statement, for one or more selected objects of the following types:

Domains

Functions

Tables

Types

Views

This lets you specify a new schema for the object.

Platform Availability

To change the schema for an object

  1. Initiate a Change Schema action against one or more objects of an object type shown in the table above. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Change Category wizard:
Step Settings and tasks

Action options

From the New Owner dropdown, choose a new owner for the object.

Preview

Displays the DDL that will execute the object action. For details, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.

Topics