doc/user/content/sql/drop-owned.md
DROP OWNED drops all the objects that are owned by one of the specified roles.
Any privileges granted to the given roles on objects will also be revoked.
{{< note >}} Unlike PostgreSQL, Materialize drops all objects across all databases, including the database itself. {{< /note >}}
DROP OWNED BY <role_name> [, ...] [RESTRICT|CASCADE];
| Syntax element | Description |
|---|---|
<role_name> | The role name whose owned objects will be dropped. |
| CASCADE | Optional. If specified, remove all dependent objects. |
| RESTRICT | Optional. Do not drop anything if any non-index objects depencies exist. (Default.) |
DROP OWNED BY joe;
DROP OWNED BY joe, george CASCADE;
The privileges required to execute this statement are:
{{% include-headless "/headless/sql-command-privileges/drop-owned" %}}