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 <[email protected]> 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 <[email protected] >> <mailto:[email protected]>> 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 [email protected] >> <mailto:[email protected]>. To unsubscribe, send email to >> [email protected] >> <mailto:[email protected]>. 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 [email protected] >> <mailto:[email protected]>. >> 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 [email protected]. To unsubscribe, send email to [email protected]. 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/3927E10E-4B9A-4A5A-B2EF-678DA6FE18BE%40fargeo.com.
