DROP SCHEMA_REGISTRY

Syntax

DROP SCHEMA_REGISTRY schema_registry_name;

Description

Drops a schema registry from the organization. You cannot drop a schema registry if there exist any stores that depend on that schema registry.

Important DROP SCHEMA_REGISTRY cannot be undone. Use it with care!

Arguments

schema_registry_name

Specifies the name of the schema registry. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

Examples

Drop a schema registry

Drops the schema registry named ccsr:

demodb.public/demostore# LIST SCHEMA_REGISTRIES;
+---------------------+------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+
|  Name               |  Type      |  State     |  Uris                                    |  Owner     |  Created At                   |  Updated At                   |
+=====================+============+============+==========================================+============+===============================+===============================+
| ConfluentPlatformSR | Confluent  | ready      | https://url.to.schema.registry.listener: | sysadmin   | 2024-07-03 14:49:13 +0000 UTC | 2024-07-03 14:49:13 +0000 UTC |
|                     |            |            | 8081                                     |            |                               |                               |
+---------------------+------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+
| ccsr                | Confluent  | ready      | https://path-to-my-registry              | sysadmin   | 2024-07-03 15:42:20 +0000 UTC | 2024-07-03 15:42:20 +0000 UTC |
+---------------------+------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------++-------------------------------+-------------------------------+
demodb.public/demostore# DROP SCHEMA_REGISTRY ccsr;
+-----------------+------------+------------+------------------------------------------+
|  Type           |  Name      |  Command   |  Summary                                 |
+=================+============+============+==========================================+
| schema registry | ccsr       | DROP       | schema registry "ccsr" has been marked   |
|                 |            |            | for deletion                             |
+-----------------+------------+------------+------------------------------------------+
demodb.public/demostore# LIST SCHEMA_REGISTRIES;
+---------------------+------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+
|  Name               |  Type      |  State     |  Uris                                    |  Owner     |  Created At                   |  Updated At                   |
+=====================+============+============+==========================================+============+===============================+===============================+
| ConfluentPlatformSR | Confluent  | ready      | https://url.to.schema.registry.listener: | sysadmin   | 2024-07-03 14:49:13 +0000 UTC | 2024-07-03 14:49:13 +0000 UTC |
|                     |            |            | 8081                                     |            |                               |                               |
+---------------------+------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+

Drop a schema registry with a case-sensitive name

Drops the schema registry named ConfluentCloudSR:

demodb.public/demostore# LIST SCHEMA_REGISTRIES;
+---------------------+----------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+
|  Name               |  Type          |  State     |  Uris                                    |  Owner     |  Created At                   |  Updated At                   |
+=====================+================+============+==========================================+============+===============================+===============================+
| ConfluentPlatformSR | Confluent      | ready      | https://url.to.schema.registry.listener: | sysadmin   | 2024-07-03 14:49:13 +0000 UTC | 2024-07-03 14:49:13 +0000 UTC |
|                     |                |            | 8081                                     |            |                               |                               |
+---------------------+----------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+
| ConfluentCloudSR    | ConfluentCloud | ready      | https://abcd-efghi.us-east-2.aws.conflue | sysadmin   | 2024-07-03 14:37:03 +0000 UTC | 2024-07-03 14:37:03 +0000 UTC |
|                     |                |            | nt.cloud                                 |            |                               |                               |
+---------------------+----------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+
demodb.public/demostore# DROP SCHEMA_REGISTRY "ConfluentCloudSR";
+-----------------+------------------+------------+------------------------------------------+
|  Type           |  Name            |  Command   |  Summary                                 |
+=================+==================+============+==========================================+
| schema registry | ConfluentCloudSR | DROP       | schema registry "ConfluentCloudSR" has   |
|                 |                  |            | been marked for deletion                 |
+-----------------+------------------+------------+------------------------------------------+
demodb.public/demostore# LIST SCHEMA_REGISTRIES;
+---------------------+------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+
|  Name               |  Type      |  State     |  Uris                                    |  Owner     |  Created At                   |  Updated At                   |
+=====================+============+============+==========================================+============+===============================+===============================+
| ConfluentPlatformSR | Confluent  | ready      | https://url.to.schema.registry.listener: | sysadmin   | 2024-07-03 14:49:13 +0000 UTC | 2024-07-03 14:49:13 +0000 UTC |
|                     |            |            | 8081                                     |            |                               |                               |
+---------------------+------------+------------+------------------------------------------+------------+-------------------------------+-------------------------------+