Re: HELP! (AKA Those whacky users...)

From: S. Kannan <skannan_at_cardinal.fs.com>
Date: 1995/12/08
Message-ID: <4a9t09$shp_at_cardinal.fs.com>#1/1


Tim King (tking_at_gw.dot.state.ny.us) wrote:
: This question has probably been asked 1K+ times before, but since I haven't
: seen the answer yet, I guess I'll have to ask it again!
: How do I drop a table that has a name with a trailing blank character? I
: don't know how it got there. A user called me because they were trying to
: drop it, but obviously could not by referencing the table name as they saw it.
: Database is V6 on IBM VM/ESA (Long live the dinosaur!).
: Any assistance is appreciated.
: Tim.

Enclose the table name (including the space) in quotes, in the drop table statement.

Drop table "abcd ";

--
---------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com
Mastech Systems Corporation

The above are my own comments and opinion. They do not purport that of 
anybody else.
       ** Different is Not Better. Better is not Different. **
---------------------------------------------------------------------------
Received on Fri Dec 08 1995 - 00:00:00 CET

Original text of this message