Re: Nuwbie question

Posted in 1999

Joe Lumbley — Tue, 2 Mar 1999 21:49:11 GMT — source: Informix-list mailing list archive (1991-1998)

Carlson@WHSmith (carlson1@bellsouth.net) wrote: : Was this a system-generated number? If so, you may need to include the : index name inside quotes: : drop index " 167" Note the first character is a space! Joe : 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 -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" The DBA Survival Guide, Second Edition will cover NT, 7.X through 7.3, graphical utilities, more survival hints. Publish date: 12/16/98 FINALLY! ---------------------------------------------------------------------------