Deleting Database Collections

Ask the community
,
1

Hello everyone, i’m new here but i’m really struggeling with the following :

I’ve managed to create a Database and all works fine. While setting up the Database and the collections i’ve created a couple of collections to test out how it works.
Now i want to delete the collections i’ve made for trying out but i cant seem to fine where to delete them from the database.
Can anyone help me and point me in the right direction?
Thanks in advance ,
With kind regards
Colin.

546×1124 57.6 KB

5 Likes
2

Hi Colin,

At the moment it is not possible to delete collections.

Feel free to post your request in our Feature Request forum

3

I’m also interested in this question for identical reasons. If you can’t delete can you edit the collection name? If so then how (please)

4

Hi Mike,
At the moment it is not possible as well.

Roi

5

Well, I’ve seen this sort of issue in other database development tools. It makes you scared to mistype a table (sorry, Collection) name because you will be stuck with it forever. This is the first time Wix has disappointed me. Ah well. Your only solution is to rigorously plan your database beforehand using some other SQL toolset and very carefully transfer your results into Wix.

6

I am also struggling with this issue. :frowning: Is there an update on the horizon that will allow this flexibility? It is not at all unusual (in fact it is customary) for architects to “play” with the site before entering a final design. Presumably this is why you can choose when to publish. Is there no way to do this?

Thank you.

7

Well, you could just go to Site History and roll the site back to before you added the Collection…

8

Hmmm… does that actually work!? I want to try it! :slight_smile:

9

OK!! Awesome! That worked great! I didn’t think that would affect the backend. :slight_smile: Thank you!

10

Worked for me before I posted it. I just plan to be diligent with Saving and Publishing until they actually implement a Delete function, which is kind of ludicrous to not have.

11

yes - it is ludicrous! BUT - thank you very much for the interim fix!! I too will be especially careful as I continue! :slight_smile:

12

Hey!

Yeah, that’s really annoying that you can’t delete collection, so this feature will definitely be available some time in the future, but let’s ignore specific timeline for now.

Meanwhile, what would be your expectations from such a functionality?

  1. Would it be even more annoying if you could permanently delete Collection, and not revert this action? Or, is it a must to have a Trash (soft delete), but then not be able to create the collection with the same name until the permanent deletion (hard delete)?
  2. What would you expect to happen with your Dynamic Page, Datasets, code, and reference fields in another collections when you delete collection?

Would really appreciate your thoughts!

13

I think forcing data integrity is key here. If there are collection references that can be identified they should be highlighted to the user so they can deal with them first before being allowed to remove the item. I would hope renaming the collection should be trivial since the name will be associated with a unique collection id (of course ;)). The hard job is publishing the changes. The last thing you want is a user finding invalid links and references.

14

Wix code has a very particular purpose so I have to agree with Martin - this can’t be a free-for-all and data integrity needs to be preserved - at least within the database. One option might be to “offer” to delete all other “hooks” into the collection from other collections and of course the associated data in all of those records. The developer can have the option to cancel the delete operation or accept the changes (and I don’t think most would). The issue with code is a bigger deal, but at what point should the developer be expected to manage their own code? I would say that if you’re kicking around in the code and the backend, it should probably be your (the developer’s) responsibility to keep it clean. That’s my two cents! :smiling_face:

15

Agree to a point as I hate having things that are unused and not able to clear them off the system, but if you have no link to the database on a page, then they are really not of any consequence other then cluttering your list of databases

16

Thanks everyone for your input! You have great suggestions here.

17

On a side note, I see that you can move fields in your database. I know this can create issues at times with databases, but not sure about wix. But in trying to actually move, I find they end up just reverting back to original order. Being able to move fields to a logical order helps when building and editing, helps when going thru list to make connections…so logical order is nice. So is moving a no-no in wix database, and actually an option?

18

Hi
I manged to delete the database folder, Hope this may be useful for you guys

  1. Right click on the database folder you want to delete and click on “Insert”
  2. On the right side of the screen a html code page will appear in 3 sections, in the top section point your cursor on code
  3. ==$0 , instantly you will see the database folder in the left pane is being highlighted.
  4. Now delete only this code
  5. ==$0 and save, your database folder will be deleted.

Thanks :slight_smile:

19

Hi Sanjay,

This method will not work. You are only removing the collection from the current view.
The database itself is left unaffected and you should see it reappear if you refresh the editor.

20

Yes, Ido the DB folder appeared again when i refreshed. Sorry for my comment without validation. Can you please suggest if there is a way to delete. Thanks