LucidDbAppLib DROP SCHEMA IF EXISTS

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Example 5 Source Code

Syntax

call applib.drop_schema_if_exists(schemaName, restrictOrCascade);

Purpose

Tries to drop a schema if it exists, otherwise does nothing.

Parameters

• schemaName: name of schema to be dropped
• restrictOrCascade: only legal values are 'CASCADE' (delete schema along with everything contained in it) and 'RESTRICT' (only delete empty schemas).

Example

call applib.drop_schema_if_exists('TESTSCHEMA', 'RESTRICT');

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/util/DropSchemaIfExistsUdp.java