Drop user or drop schema?

CrateDB Cloud
,
1

is there an easy way to drop a schema or user in CrateDB? I was not able to find anything in the documentation about it.

2

You can drop a user, but not a schema currently. Schemas are implicitly created.

2 Likes
3

I can see my schema from the output of the “show schema;” command however I am unable to drop it. I see no drop schema command in the docs. The schema is listed but not shown in the following output. I am not seeing the username listed from the following output. SELECT * FROM sys.users;

4

thanks for the quick reply!

5

FYI there are open issues regarding the support of explicit schemas:

which you can upvote.

And they depend on a large refactoring of the internal representation of those metadata: First class table & partitions within cluster state · Issue #11939 · crate/crate · GitHub which we currently work on.

6

Thank you for sharing this information!

1 Like