Change Schema

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

• PSTGRS *

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

• Change Owner