Contents Menu Expand Light mode Dark mode Skip to content

Join our webinar on Modern Data Pipelines for Smart Factories​ on Jun 26th

Register Now
  • Product
    • Database
      • Overview
      • SQL examples
      • Integrations
      • Security
    • Data models
      • Time-series
      • Document/JSON
      • Vector
      • Full-text
      • Spatial
      • Relational
  • Use cases
    • Real-time analytics
    • Hybrid search
    • AI/ML integration
    • AI chatbots
    • Internet of Things
    • Geospatial analytics
    • Log & event analysis
  • Industries
    • Energy
    • Financial Services
    • FMCG
    • Logistics
    • Manufacturing
    • Oil, gas & mining
    • Smart city solutions
    • Technology platforms
    • Telco
    • Transportation
  • Resources
    • Customer stories
    • Academy
    • Asset library
    • Blog
    • Events
  • Developer
    • Documentation
    • Drivers and tools
    • Community
    • GitHub
    • Support
  • Pricing
  • Login
  • Get Started
  • Overview
  • CrateDB Cloud
  • Guides and Tutorials
  • Reference Manual
    • Concepts
    • CLI tools
    • Configuration
    • General use
    • Administration
    • SQL syntax
      • General SQL
      • SQL Statements
        • ALTER CLUSTER
        • ALTER PUBLICATION
        • ALTER TABLE
        • ALTER USER
        • ANALYZE
        • BEGIN
        • START TRANSACTION
        • COMMIT
        • COPY FROM
        • COPY TO
        • CREATE ANALYZER
        • CREATE BLOB TABLE
        • CREATE FUNCTION
        • CREATE PUBLICATION
        • CREATE REPOSITORY
        • CREATE SNAPSHOT
        • CREATE SUBSCRIPTION
        • CREATE TABLE
        • CREATE TABLE AS
        • CREATE USER
        • CREATE VIEW
        • DEALLOCATE
        • DELETE
        • DENY
        • DISCARD
        • DROP ANALYZER
        • DROP FUNCTION
        • DROP PUBLICATION
        • DROP REPOSITORY
        • DROP SNAPSHOT
        • DROP SUBSCRIPTION
        • DROP TABLE
        • DROP USER
        • DROP VIEW
        • END
        • EXPLAIN
        • GRANT
        • INSERT
        • KILL
        • OPTIMIZE
        • REFRESH
        • RESTORE SNAPSHOT
        • REVOKE
        • SELECT
        • SET and RESET
        • SET LICENSE
        • SET AND RESET SESSION AUTHORIZATION
        • SET TRANSACTION
        • SHOW COLUMNS
        • SHOW CREATE TABLE
        • SHOW SCHEMAS
        • SHOW TABLES
        • SHOW (session settings)
        • UPDATE
        • VALUES
    • Client interfaces
    • Appendices
  • Admin UI
  • CrateDB CLI
  • Cloud CLI
  • Drivers and Integrations
  • Support
  • Community
  • Integration Tutorials
  • Sample Applications
  • Academy

DROP SUBSCRIPTION¶

See also

CREATE SUBSCRIPTION

Table of contents

  • Synopsis

  • Description

  • Parameters

Synopsis¶

DROP SUBSCRIPTION [ IF EXISTS ] name

Description¶

Removes an existing subscription from the cluster and stops the replication. Existing tables will turn into regular writable tables. It’s not possible to resume dropped subscription.

Parameters¶

name

The name of the subscription to be deleted.

Next
DROP TABLE
Previous
DROP SNAPSHOT
  Feedback

  Suggest improvement

  Edit page

  View page source

4.8
On this page
  • DROP SUBSCRIPTION
    • Synopsis
    • Description
    • Parameters

Subscribe to the CrateDB Newsletter now

  • Imprint
  • Contact
  • Legal
Follow us
Follow us on X Follow us on LinkedIn Follow us on Facebook Follow us on Instagram Follow us on Facebook