[ http://issues.apache.org/jira/browse/DDLUTILS-21?page=comments#action_12330956 ]
Thomas Dudziak commented on DDLUTILS-21: ---------------------------------------- Unfortunately I have no Sql Server to test against at the moment. But I wonder, does this work when using a table name like 'SomeTable' (note the upper case). If you could verify for me that such mixed case names work with your patch when not in delimited mode, then I'll apply it ASAP. Tom > Sql Server drop statements fail without delimited identifiers > ------------------------------------------------------------- > > Key: DDLUTILS-21 > URL: http://issues.apache.org/jira/browse/DDLUTILS-21 > Project: DdlUtils > Type: Bug > Reporter: Richard Bounds > Assignee: Thomas Dudziak > Attachments: patch.txt > > The drop statements that are generated for sql server are prefixed by: > IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'tablename') > Without a delimeter being specified the statement changes to: > IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = tablename) > ...which fails (note the lack of quotes around tablename). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
