Contents Menu Expand Light mode Dark mode Skip to content

Real-Time Unified Data Layers: A New Era for Scalable Analytics, Search, and AI

Download the White Paper
  • 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
  • Docs Home
  • 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 ROLE
        • ALTER USER
        • ANALYZE
        • BEGIN
        • CLOSE
        • COMMIT
        • COPY FROM
        • COPY TO
        • CREATE ANALYZER
        • CREATE BLOB TABLE
        • CREATE FOREIGN TABLE
        • CREATE FUNCTION
        • CREATE PUBLICATION
        • CREATE REPOSITORY
        • CREATE ROLE
        • CREATE SERVER
        • CREATE SNAPSHOT
        • CREATE SUBSCRIPTION
        • CREATE TABLE
        • CREATE TABLE AS
        • CREATE USER
        • CREATE USER MAPPING
        • CREATE VIEW
        • DEALLOCATE
        • DECLARE
        • DELETE
        • DENY
        • DISCARD
        • DROP ANALYZER
        • DROP FOREIGN TABLE
        • DROP FUNCTION
        • DROP PUBLICATION
        • DROP REPOSITORY
        • DROP ROLE
        • DROP SERVER
        • DROP SNAPSHOT
        • DROP SUBSCRIPTION
        • DROP TABLE
        • DROP USER
        • DROP USER MAPPING
        • DROP VIEW
        • END
        • EXPLAIN
        • FETCH
        • GRANT
        • INSERT
        • KILL
        • OPTIMIZE
        • REFRESH
        • RESTORE SNAPSHOT
        • REVOKE
        • SELECT
        • SET and RESET
        • SET LICENSE
        • SET AND RESET SESSION AUTHORIZATION
        • SET TRANSACTION
        • SHOW (session settings)
        • SHOW COLUMNS
        • SHOW CREATE TABLE
        • SHOW SCHEMAS
        • SHOW TABLES
        • START TRANSACTION
        • UPDATE
        • VALUES
        • WITH
    • 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

5.9
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