DROP PROJECTION
Marks a projection to drop from the catalog so it is unavailable to user queries.
Syntax
DROP PROJECTION [ IF EXISTS ] { [[database.]schema.]projection[,…] } [ RESTRICT | CASCADE ]
Parameters
IF EXISTS
|
Specifies not to report an error if the projection to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them. |
[database.]schema
|
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
projection
|
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
Superuser, or owner of the anchor table
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.