OWNER TO

Description

Changes the Owner of an existing table.

Click here to navigate to the PostgreSQL documentation page for this syntax.

The Alter Table owner must be handled manually

Grammar Syntax

ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
    OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

Sample Source Patterns

PostgreSQL

ALTER TABLE Table3 *
OWNER TO NewOwner;

Snowflake

-- ** MSC-WARNING - MSC-PG0000 - USER PRIVILEGES MUST BE HANDLED MANUALLY **
--ALTER TABLE Table3 *
--OWNER TO NewOwner
                 ;

Related EWIs

1. MSC-PG0000: User privileges must be handled manually.