DROP PROJECT changes the project's status flag to INACTIVE. Inactive projects will not usually be displayed. This is to maintain history of project runs until they are explicitly deleted.

Syntax

DROP PROJECT { '<project_name>' | ID '<id>' }

Arguments

  • ‘project_name’ - user specified project name added during CREATE or ALTER PROJECT command. These are unique for all active projects, but not for deactivated projects.

  • ‘id’ - Cirro assigned project ID. Once a project has been created it can be referenced by ID (alter, execute, drop).

Additional Information

  • Only inactive projects can be dropped.

  • EXECUTE PROJECT and DROP PROJECT should fail with an error if the project is currently executing.

  • ALTER_PROJECT STATUS - only an INACTIVE project can be dropped.

Examples

DROP PROJECT 'FutureTask' ;

See Also