topic Re: Ignore Pre/Post SQL DROP TABLE Errors in Alteryx Designer Desktop Discussions

Ignore Pre/Post SQL DROP TABLE Errors

DParanka — Fri, 17 Jun 2022 18:08:12 GMT

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

Re: Ignore Pre/Post SQL DROP TABLE Errors

DParanka — Fri, 17 Jun 2022 18:16:38 GMT

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