[feat]: Right Click on Table - DROP table

[millerjp]

This very similar to #542 other than we do the DROP with IF EXISTS in the CQL and also use Consistency ALL;

We want IF EXISTS so it throws an error if the table no longer exists.

The warning will be different also

---

Warning: Drop Table Operation

This operation is irreversible and will permanently delete the table structure and all associated data.

• By executing this command, the entire table will be removed immediately, including:
  • All data in the table.
  • All indexes associated with the table.
• Materialized Views: If this table has any materialized views, they must be dropped first. An error will be thrown if any materialized views still exist.
• Table Structure: The schema definition of the table will be lost and cannot be recovered.
• Snapshots: If your Cassandra cluster is configured to take snapshots before dropping tables, a snapshot of the table's current data will be created for recovery purposes. Remember to remove this snapshot if they are not needed.
  • Clean up snapshots: Use nodetool clearsnapshot to remove snapshots if they are no longer needed.
  • Disable automatic snapshots: Modify cassandra.yaml to disable snapshots if you do not want this behavior.

Please confirm that you want to proceed with this operation, understanding its irreversible nature, the need to drop any associated materialized views first, and the necessity to manage snapshots.

---

eg

CONSISTENCY ALL;
DROP TABLE <keyspace>.<table> IF EXISTS