Drops an existing Relation. It can only be executed by the Relation owner. A Relation cannot be dropped if there exists any queries that depend on that Relation. Note that deleting the Relation does not delete the Relation's underlying Topic.
DROP RELATION cannot be undone. Use it with care!
A Relation cannot be dropped if there exist any references to that Relation
The name of the Relation to drop. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.
Drop a Relation using default Database and Schema
The following shows how to drop the Relation named pageviews: