Removes the specified image repository from the current or specified schema.
DROP IMAGE REPOSITORY [ IF EXISTS ] <name>
Copy
Parameters¶name
Specifies the identifier for the repository to drop.
A role used to execute this operation must have the following privileges at a minimum:
Privilege
Object
Notes
OWNERSHIP
Image repository
The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema.
For instructions on creating 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¶Dropping an image repository while services are running that reference images in that repository can cause problems. Currently running service instances and jobs will continue to run, but any attempt to create a new service instance will fail.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
The following example drops the repository named tutorial_repository
:
DROP IMAGE REPOSITORY tutorial_repository;
Copy
+-------------------------------------------+ | status | |-------------------------------------------| | TUTORIAL_REPOSITORY successfully dropped. | +-------------------------------------------+
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4