Contents Menu Expand Light mode Dark mode Skip to content
  • Product
    • Editions
      • CrateDB Cloud
      • CrateDB Enterprise
      • CrateDB OSS
    • Features
      • Overview
      • High cardinality
      • SQL syntax
      • Integrations
      • Security
    • Data models
      • Time-series
      • Document/JSON
      • Vector
      • Full-text
      • Spatial
      • Relational
  • Solutions
    • By use cases | Real-time
      • Industrial Analytics
      • AI operations
      • Application analytics
    • By industry
      • Manufacturing
      • Energy
      • FMCG
      • Logistics
      • Oil, Gas & Mining
      • Transportation
      • SaaS
      • Media & Entertainment
  • Resources
    • Customer stories
    • Academy
    • Asset library
    • Blog
    • Guides
    • Events
  • Developer
    • Documentation
    • Drivers and tools
    • Community
    • GitHub
    • Support
  • Pricing
  • Login
  • Get Started
  • Overview
    • Getting Started
      • Build

      • Load data into CrateDB
        • Connect / Drivers
          • Integrations
            • All Features
              • Operations

              • Installation
                • Administration
                  • Performance guides
                    • References

                    • CrateDB Cloud
                      • CrateDB
                        • Concepts
                          • Joins
                          • Clustering
                          • Storage and consistency
                          • Resiliency
                        • CLI tools
                        • Configuration
                          • Node-specific settings
                          • Cluster-wide settings
                          • Session settings
                          • Logging
                          • Environment variables
                        • General use
                          • Data definition
                            • Creating tables
                            • Data types
                            • System columns
                            • Generated columns
                            • Constraints
                            • Storage
                            • Partitioned tables
                            • Sharding
                            • Replication
                            • Shard allocation filtering
                            • Column policy
                            • Fulltext indices
                            • Fulltext analyzers
                            • Show Create Table
                            • Views
                            • Altering tables
                          • Data manipulation
                          • Querying
                            • Selecting data
                            • Joins
                            • Union
                            • Refresh
                            • Fulltext search
                            • Geo search
                          • Built-in functions and operators
                            • Scalar functions
                            • Aggregation
                            • Arithmetic operators
                            • Table functions
                            • Comparison operators
                            • Array comparisons
                            • Subquery expressions
                            • Window functions
                          • User-defined functions
                          • Blobs
                          • Optimistic Concurrency Control
                          • Information schema
                        • Administration
                          • System information
                          • Runtime configuration
                          • User management
                          • Privileges
                          • Authentication
                            • Authentication Methods
                            • Host-Based Authentication (HBA)
                          • Secured communications (SSL/TLS)
                          • Optimization
                          • Jobs management
                          • JMX monitoring
                          • Snapshots
                          • Logical replication
                          • Cloud discovery
                          • Usage Data Collector
                        • SQL syntax
                          • General SQL
                            • Constraints
                            • Value expressions
                            • Lexical structure
                          • 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
                          • HTTP endpoint
                          • PostgreSQL wire protocol
                        • Appendices
                          • Release Notes
                            • Unreleased Changes
                            • Version 4.8.4
                            • Version 4.8.3
                            • Version 4.8.2
                            • Version 4.8.1
                            • Version 4.8.0
                            • Version 4.7.3
                            • Version 4.7.2
                            • Version 4.7.1
                            • Version 4.7.0
                            • Version 4.6.8
                            • Version 4.6.7
                            • Version 4.6.6
                            • Version 4.6.5
                            • Version 4.6.4
                            • Version 4.6.3
                            • Version 4.6.2
                            • Version 4.6.1
                            • Version 4.6.0
                            • Version 4.5.5
                            • Version 4.5.4
                            • Version 4.5.3
                            • Version 4.5.2
                            • Version 4.5.1
                            • Version 4.5.0
                            • Version 4.4.3
                            • Version 4.4.2
                            • Version 4.4.1
                            • Version 4.4.0
                            • Version 4.3.4
                            • Version 4.3.3
                            • Version 4.3.2
                            • Version 4.3.1
                            • Version 4.3.0
                            • Version 4.2.7
                            • Version 4.2.6
                            • Version 4.2.5
                            • Version 4.2.4
                            • Version 4.2.3
                            • Version 4.2.2
                            • Version 4.2.1
                            • Version 4.2.0
                            • Version 4.1.8
                            • Version 4.1.7
                            • Version 4.1.6
                            • Version 4.1.5
                            • Version 4.1.4
                            • Version 4.1.3
                            • Version 4.1.2
                            • Version 4.1.1
                            • Version 4.1.0
                            • Version 4.0.12
                            • Version 4.0.11
                            • Version 4.0.10
                            • Version 4.0.9
                            • Version 4.0.8
                            • Version 4.0.7
                            • Version 4.0.6
                            • Version 4.0.5
                            • Version 4.0.4
                            • Version 4.0.3
                            • Version 4.0.2
                            • Version 4.0.1
                            • Version 4.0.0
                            • Version 3.3.6
                            • Version 3.3.5
                            • Version 3.3.4
                            • Version 3.3.3
                            • Version 3.3.2
                            • Version 3.3.1
                            • Version 3.3.0
                            • Version 3.2.8
                            • Version 3.2.7
                            • Version 3.2.6
                            • Version 3.2.5
                            • Version 3.2.4
                            • Version 3.2.3
                            • Version 3.2.2
                            • Version 3.2.1
                            • Version 3.2.0
                            • Version 3.1.6
                            • Version 3.1.5
                            • Version 3.1.4
                            • Version 3.1.3
                            • Version 3.1.2
                            • Version 3.1.1
                            • Version 3.1.0
                            • Version 3.0.7
                            • Version 3.0.6
                            • Version 3.0.5
                            • Version 3.0.4
                            • Version 3.0.3
                            • Version 3.0.2
                            • Version 3.0.1
                            • Version 3.0.0
                            • Version 2.3.11
                            • Version 2.3.10
                            • Version 2.3.9
                            • Version 2.3.8
                            • Version 2.3.7
                            • Version 2.3.6
                            • Version 2.3.5
                            • Version 2.3.4
                            • Version 2.3.3
                            • Version 2.3.2
                            • Version 2.3.1
                            • Version 2.3.0
                            • Version 2.2.7
                            • Version 2.2.6
                            • Version 2.2.5
                            • Version 2.2.4
                            • Version 2.2.3
                            • Version 2.2.2
                            • Version 2.2.1
                            • Version 2.2.0
                            • Version 2.1.10
                            • Version 2.1.9
                            • Version 2.1.8
                            • Version 2.1.7
                            • Version 2.1.6
                            • Version 2.1.5
                            • Version 2.1.4
                            • Version 2.1.3
                            • Version 2.1.2
                            • Version 2.1.1
                            • Version 2.1.0
                            • Version 2.0.7
                            • Version 2.0.6
                            • Version 2.0.5
                            • Version 2.0.4
                            • Version 2.0.3
                            • Version 2.0.2
                            • Version 2.0.1
                            • Version 2.0.0
                            • Version 1.2.0
                            • Version 1.1.6
                            • Version 1.1.5
                            • Version 1.1.4
                            • Version 1.1.3
                            • Version 1.1.2
                            • Version 1.1.1
                            • Version 1.1.0
                            • Version 1.0.6
                            • Version 1.0.5
                            • Version 1.0.4
                            • Version 1.0.3
                            • Version 1.0.2
                            • Version 1.0.1
                            • Version 1.0.0
                          • SQL compatibility
                          • SQL standard compliance
                          • Resiliency Issues
                          • Glossary
                      • Tools

                      • Admin UI
                        • CrateDB CLI
                          • Cloud CLI
                            • CrateDB MCP
                            • CrateDB Toolkit
                            • Support
                            • Community

                            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
                            • 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