Update existing table in Sybase using Alteryx

[pereisyd]

Hi,

I'm using Alteryx 2018.4.4, and trying to update a table with a primary key.

The table structure in Alteryx is exactly as is in the DB. Alteryx is even able to identify the Primary key in the DB table (screenshot attached). However, I still receive the following error when I run the workflow:

"Primary Key required for Update option"

Thoughts?

[bbak91 · Accepted solution]

Can you take a look at the thread here and let me know if any of the solutions help? https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Primary-Key-Required-for-Update-Option...

[pereisyd · Accepted solution]

USE <DB> helped.

Thank you.