DROP PROJECTION
Marks a projection to drop from the catalog so it is unavailable to user queries.
Syntax
DROP PROJECTION { [schema.]proj-name [ , ...] } ... [ RESTRICT | CASCADE ]
Parameters
schema |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
projection-name
|
Specifies a projection to drop:
See Projection Naming for projection name conventions. |
RESTRICT | CASCADE
|
Specifies whether to drop the projection when it contains objects:
|
Privileges
To drop a projection, two requirements apply:
- Ownership of the projection's anchor table
- Ownership of the projection's schema, or USAGE privileges on the schema
Restrictions
The following restrictions apply to dropping a projection:
- The projection cannot be the anchor table's superprojection.
- You cannot drop a buddy projection if doing so violates system K-safety.
- Another projection must be available to enforce the same primary or unique key constraint.