Dropping table with special chars in name

Posted in 2008

Erhard Eiselen — Wed, 28 May 2008 08:58:08 — source: IIUG Forums & Mailing Lists

Hi All I hve a table in one of my databases that was created by some idiot Microsoft process, that has spaces in the name. Is there a way, other than the normal "drop table" command to get rid of it? Thanks in advance Eis E-mail is not necessarily secure or error free as information could arrive late or contain viruses or could be incomplete, intercepted, corrupted, lost or destroyed. It is the responsibility of the named recipient(s) to ensure that E-mails are virus free.

↪ replying to Erhard Eiselen

Art Kagel — Wed, 28 May 2008 12:52:28 — source: IIUG Forums & Mailing Lists

Set DELIMIDENT=1 in your user environment then you can: DROP TABLE "table name with spaces"; On Wed, May 28, 2008 at 4:58 AM, Erhard Eiselen <eis@tad.co.za> wrote: > Hi All > I hve a table in one of my databases that was created > by some idiot Microsoft process, that has spaces in the > name. Is there a way, other than the normal "drop table" > command to get rid of it? > Thanks in advance > Eis > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitely or implicitely. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

↪ replying to Art Kagel

Erhard Eiselen — Wed, 28 May 2008 13:01:26 — source: IIUG Forums & Mailing Lists

Thanks Art That works 100% Eis -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: 28 May 2008 14:52 To: ids@iiug.org Subject: Re: Dropping table with special chars in name [12228] Set DELIMIDENT=1 in your user environment then you can: DROP TABLE "table name with spaces"; On Wed, May 28, 2008 at 4:58 AM, Erhard Eiselen <eis@tad.co.za> wrote: > Hi All > I hve a table in one of my databases that was created > by some idiot Microsoft process, that has spaces in the > name. Is there a way, other than the normal "drop table" > command to get rid of it? > Thanks in advance > Eis > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitely or implicitely. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. E-mail is not necessarily secure or error free as information could arrive late or contain viruses or could be incomplete, intercepted, corrupted, lost or destroyed. It is the responsibility of the named recipient(s) to ensure that E-mails are virus free.