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
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