Nuwbie question

Posted in 1999

BZ — Tue, 02 Mar 1999 10:05:00 +0800 — source: Informix-list mailing list archive (1991-1998)

I try to - drop index 167 - but all I get is a - syntax error message. The problem appears to be the index' name beeing a number. How can I get around this ? And how can I use a wildcard in the index' name if I wanted to ? Thks in advance

↪ replying to BZ

Carlson@WHSmith — Tue, 02 Mar 1999 12:09:18 -0500 — source: Informix-list mailing list archive (1991-1998)

Was this a system-generated number? If so, you may need to include the index name inside quotes: drop index " 167" John Carlson Informix DBA WHSmith USA BZ wrote: > > I try to - drop index 167 - but all I get is a - syntax > error message. > The problem appears to be the index' name beeing a number. > How can I get around this ? > > And how can I use a wildcard in the index' name if I wanted to ? > > Thks in advance