DROP CHANGELOG

Synopsis

DROP CHANGELOG changelog_name;

Description

Drops an existing Changelog. It can only be executed by the Changelog owner. A Changelog cannot be dropped if there exists any queries that depend on that Changelog. Note that deleting the Changelog does not delete the Changelog's underlying Entity.

DROP CHANGELOG cannot be undone. Use it with care!

A Changelog cannot be dropped if there exist any references to that changelog

Arguments

changelog_name

The name of the Changelog to drop. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Example

Drop a Changelog using default Database and Schema

The following shows how to drop the Changelog named users_log:

demodb.public/demostore# LIST CHANGELOGS;
+------------+------------+------------+------------+------------------------------------------+-------------------------------+-------------------------------+
|  Name      |  Type      |  Owner     |  State     |  Properties                              |  Created At                   |  Updated At                   |
+============+============+============+============+==========================================+===============================+===============================+
| users      | changelog  | sysadmin   | created    | { "value.format": "json", "topic":       | 2024-07-02 21:42:03 +0000 UTC | 2024-07-02 21:42:05 +0000 UTC |
|            |            |            |            | "users", "store": "demostore",           |                               |                               |
|            |            |            |            | "primary.key": "userid" }                |                               |                               |
+------------+------------+------------+------------+------------------------------------------+-------------------------------+-------------------------------+

demodb.public/demostore# DROP CHANGELOG "users";
+------------+---------------------+------------+------------------------------------------+
|  Type      |  Name               |  Command   |  Summary                                 |
+============+=====================+============+==========================================+
| query      | demodb.public.users | DROP       | relation demodb.public.users was dropped |
+------------+---------------------+------------+------------------------------------------+
demodb.public/demostore# LIST CHANGELOGS;
+------------+------------+------------+------------+-------------+-------------+-------------+
|  Name      |  Type      |  Owner     |  State     |  Properties |  Created At |  Updated At |
+============+============+============+============+=============+=============+=============+
+------------+------------+------------+------------+-------------+-------------+-------------+

Drop a Changelog using fully qualified name

The following shows how to drop the Changelog named UsersLog in the Database otherdb and Schema S1:

demodb.public/demostore# LIST CHANGELOGS IN SCHEMA otherdb."S1";
+------------+------------+------------+------------+------------------------------------------+-------------------------------+-------------------------------+
|  Name      |  Type      |  Owner     |  State     |  Properties                              |  Created At                   |  Updated At                   |
+============+============+============+============+==========================================+===============================+===============================+
| UsersLog   | changelog  | sysadmin   | created    | { "value.format": "json", "topic":       | 2024-07-02 21:46:40 +0000 UTC | 2024-07-02 21:46:41 +0000 UTC |
|            |            |            |            | "users", "store": "demostore",           |                               |                               |
|            |            |            |            | "primary.key": "userid" }                |                               |                               |
+------------+------------+------------+------------+------------------------------------------+-------------------------------+-------------------------------+
demodb.public/demostore# DROP CHANGELOG otherdb."S1"."UsersLog";
+------------+---------------------+------------+------------------------------------------+
|  Type      |  Name               |  Command   |  Summary                                 |
+============+=====================+============+==========================================+
| query      | otherdb.S1.UsersLog | DROP       | relation otherdb.S1.UsersLog was dropped |
+------------+---------------------+------------+------------------------------------------+
demodb.public/demostore# LIST CHANGELOGS IN SCHEMA otherdb."S1";
+------------+------------+------------+------------+-------------+-------------+-------------+
|  Name      |  Type      |  Owner     |  State     |  Properties |  Created At |  Updated At |
+============+============+============+============+=============+=============+=============+
+------------+------------+------------+------------+-------------+-------------+-------------+