DROP STOGROUP - Delete storage group

You use DROP STOGROUP to delete a storage group. You cannot delete a storage group if it is being used for spaces or has been entered in the media table
(see the “ Core manual”).

The STOGROUPS view of the INFORMATION_SCHEMA provides you with information on which storage groups have been defined (see chapter "Information schemas").

The current authorization identifier must own the storage group.

---

DROP STOGROUP stogroup RESTRICT

---

stogroup

Name of the storage group. The storage group cannot be deleted if it is being used.

You can qualify the name of the storage group with a database name.

See also

CREATE STOGROUP, ALTER STOGROUP