Oninit cdi / Archive
Talk to an expert →

Drop table with incorrect tablename

Posted in 2008

Topics: Versions, Editions & End-of-Life

Habichtsberg, Reinhard — — source: Usenet: comp.databases.informix

Hi all, I want to drop a table with an incorrect tablename. >From systables: tabname rv-extern owner arcisadm partnum 10486210 tabid 2507 rowsize 12 ncols 1 nindexes 0 nrows 14915 created 08.08.2003 version 164298765 tabtype T locklevel P npused 119 fextsize 16 nextsize 16 flags 0 drop table rv-extern; # Syntax Error 201 Problem is the "-" (hyphen). Objectnames must start with a letter or "_" and contain letters, digits, or "_". Don't know how the table was created. How can I drop that table? IDS 9.40.FC9W2. TIA, Reinhard.

↪ replying to Habichtsberg, Reinhard
Superboer — — source: Usenet: comp.databases.informix

Hello Reinhard. afaikr: export DELIMIDENT=y try: drop table "rv-extern"; Superboer. On 15 mei, 15:26, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi all, > > I want to drop a table with an incorrect tablename. > > >From systables: > > tabname rv-extern > owner arcisadm > partnum 10486210 > tabid 2507 > rowsize 12 > ncols 1 > nindexes 0 > nrows 14915 > created 08.08.2003 > version 164298765 > tabtype T > locklevel P > npused 119 > fextsize 16 > nextsize 16 > flags 0 > > drop table rv-extern; # Syntax Error 201> > Problem is the "-" (hyphen). Objectnames must start with a letter or "_" and > contain letters, digits, or "_". > > Don't know how the table was created. How can I drop that table? > > IDS 9.40.FC9W2. > > TIA, > Reinhard.