I would like to clear the UDT data and start from scratch. see all of the UDT_* tables in the Database Manager and it looks simple enough where I could clear these tables but my fear is that there is some type of relationship where these are required. Is there a method that should be used when trying to clear UDT.
Thinking loud - did you try to set a history retention to 1 day? At the end, during the database maintenance, all older data should disappear...
Let me please know if this works for you.