DROP ORGANIZATION PROFILE¶

Removes an organization profile.

See also:: ALTER ORGANIZATION PROFILE, CREATE ORGANIZATION PROFILE, DESCRIBE AVAILABLE ORGANIZATION PROFILE, DESCRIBE ORGANIZATION PROFILE, SHOW AVAILABLE ORGANIZATION PROFILES, SHOW ORGANIZATION PROFILES, SHOW VERSIONS IN ORGANIZATION PROFILE

Syntax¶

DROP ORGANIZATION PROFILE <name>

Copy

Parameters¶

name

Specifies the identifier for the organization profile to drop.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case sensitive. For information about identifier syntax, see Identifier Requirements.

Access control requirements¶

A role used to execute this SQL command must have either of the following privileges at a minimum:

Privilege	Object	Notes
OWNERSHIP	Organization profile	Executing this command with any other role returns an error.

To create a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes¶

Dropped organization profiles cannot be recovered; they must be recreated. An organization profile cannot be dropped if it is associated with an organizational listing.

Examples¶

The following example drops the organization profile named MYORGANIZATIONPROFILE:

DROP ORGANIZATION PROFILE myorganizationprofile;

Copy

+---------------------------------------------+
| status                                      |
|---------------------------------------------|
| MYORGANIZATIONPROFILE successfully dropped. |
+---------------------------------------------+