Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Ignore Pre/Post SQL DROP TABLE Errors

DParanka
5 - Atom

Using the output tool to write to an MS SQL Server table.  If I set the option, "Ignore Pre/Post SQL DROP TABLE Errors" to True, will it ignore an error from a DROP INDEX statement or an "ALTER TABLE ... DROP CONSTRAINT" statement?  Thank you

1 REPLY 1
DParanka
5 - Atom

Apologies, I could have tested it out before posting...

 

This scenario does NOT ignore an error from a DROP INDEX statement, and this scenario does NOT ignore an error from an  "ALTER TABLE ... DROP CONSTRAINT" statement

Labels
Top Solution Authors