DROP STORAGE [IF EXISTS] name

Drop a storage.

An error will be produced if storage does not exist unless an IF EXISTS clause is provided.

Storage can be dropped only if it has no partitions and is not included in the Pipeline.

main storage cannot be dropped.

Examples #

-- Create first storage
CREATE STORAGE A
ALTER PIPELINE A

-- Create second storage
CREATE STORAGE B
ALTER PIPELINE B

-- Drop first storage
DROP STORAGE A

See also SHOW STORAGES, CREATE STORAGE, DROP PARTITIONS