Fully Deleting a Datatype

Unknown

Fully Deleting a Datatype

Unknown

We accidentally created an incorrect datatype with a particular name. We deleted it and attempted to create the correct datatype with the same name, but we got an error about there being an existing table.

We tried doing an entity delete and clear on it, but the table still remains.

Is this something we can do from inside decisions or do we need to go into the database itself and manually delete it?

Unknown

For the safety of the end users, we typically only logically delete data structures, which explains why youre having trouble generating a type of the same name. While its certainly possible to delete the table directly using SSMS or a query, itll leave obsolete references behind in different tables.

We typically recommend generating the data structure of the same name in a new designer folder in Decisions. That way you can give it the same unique name, but itll have a slightly different namespace and you shouldnt hit any validation issues. After you generate it, you can move the data structure to the same folder where you typically keep your other structures in order to keep things tidy.