Lily, The basics are this:
*** delete from ontologies cascade where [some condition is met] *** A few points of note: - This will delete all ontologies meeting the where condition and any child records in other tables containing those ontologyid’s as foreign keys. - On the where condition, you will likely filter on ontologyid or name. - Before running the sql, delete any models or branches that reference the ontology you want to delete. If you don’t do that, this statement may delete them, but I can’t predict the consequences. - Probably obvious, but be sure to have a backout plan (like a db backup) in case of unintended consequences. Good luck! Adam --- Adam Lodge Geospatial Systems Consultant Farallon Geographics > On Apr 28, 2020, at 10:47 AM, Adam Lodge <alo...@fargeo.com> wrote: > > Hi Lily, > > You are right. There is no Arches command, but I’ve done it before with sql. > I’ll write something for you and send it your way. > > Best, > Adam > > --- > Adam Lodge > Geospatial Systems Consultant > Farallon Geographics > >> On Apr 27, 2020, at 7:08 PM, Lily Pregill <lpreg...@getty.edu >> <mailto:lpreg...@getty.edu>> wrote: >> >> Hi, >> >> We have multiple versions of an ontology loaded in a v.5 instance. I'm doing >> a little house-keeping and would like to remove the unused, old ontology >> version. I checked the documentation but didn't see a command to remove an >> ontology, only to load one. Suggestions on how to accomplish this would be >> very much appreciated. >> >> Thank you! >> Lily >> >> -- >> -- To post, send email to archesproject@googlegroups.com >> <mailto:archesproject@googlegroups.com>. To unsubscribe, send email to >> archesproject+unsubscr...@googlegroups.com >> <mailto:archesproject+unsubscr...@googlegroups.com>. For more information, >> visit https://groups.google.com/d/forum/archesproject?hl=en >> <https://groups.google.com/d/forum/archesproject?hl=en> >> --- >> You received this message because you are subscribed to the Google Groups >> "Arches Project" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to archesproject+unsubscr...@googlegroups.com >> <mailto:archesproject+unsubscr...@googlegroups.com>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/archesproject/da14ee53-3ca7-4669-902d-5054f5ec596e%40googlegroups.com >> >> <https://groups.google.com/d/msgid/archesproject/da14ee53-3ca7-4669-902d-5054f5ec596e%40googlegroups.com?utm_medium=email&utm_source=footer>. > -- -- To post, send email to archesproject@googlegroups.com. To unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to archesproject+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/3927E10E-4B9A-4A5A-B2EF-678DA6FE18BE%40fargeo.com.
