Terrific! Thanks, Adam. I’ll give it a go tomorrow.
Best,
Lily
On Apr 28, 2020, at 11:46 AM, Adam Lodge wrote:
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
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,
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 wrote:
>
> Hi,
>
> We have
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