Skip to main content
  • EN

Hi there -

 

I'm trying to make schema changes to an SDE feature class as well as an SDE table.... both have attachments and the obligatory relationship class. When I try and output to the writer using "Drop and create", the attachments (and relationship class) are deleted. But when I output using another option (e.g. truncate), they are not deleted. I'd like to use "drop and create" because we need to reorder fields and add new ones.

 

Wondering if I'm doing something wrong, or not understanding the process, or not using a much better alternative. Or possibly all 3!

This is standard functionality of all relational databases.

A relationship between tables can not exist if one of the tables does not exist.

The Drop and Create removes the table (and the database will remove the relationship).

Truncate does not remove the table, just the data.

Thanks @erik_jan. That does make sense...although it does seem a bit strange that FME is simply deleting the attachment table. All I was going to do was recreate (via drop and create) the same table with minor schema changes, so it seems the relationship with the attachment table could be re-established once the table is rebuilt, but since the attachment table is automatically deleted i don't have that option.

Although if the delete of the attachments is happening on the esri/SDE side, then it's unfair of me to blame FME!

Thanks again for the reply.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.