Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> DROP OWNED
View PDF

DROP OWNED

Function

DROP OWNED deletes the database objects of a database role.

Precautions

The role's permissions on all the database objects in the current database and shared objects (databases and tablespaces) will be revoked.

Syntax

1
 
DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ];

Parameter Description

  • name

    Specifies the role name.

    Valid value:

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes all objects that depend on the objects to be deleted.
    • RESTRICT (default): refuses to delete the object if any objects depend on it.
Parent topic: DDL Syntax