Re: PLEASE HELP! how to delete columns ...

From: ENVIPCO Management Services <envipco_at_cais2.cais.com>
Date: 1995/05/01
Message-ID: <3o3q88$i7_at_news.cais.com>#1/1

Rachakonda Satya (mahesh_at_tisl.ukans.edu) wrote:

: Hi,
 

: I am a new bee in this field. I created a database schema on Oracle
: Work Group Server. I am building the client application using Power
: Builder. There is absolutely no data in the database.
 

: Now, I want to delete a few columns from the data definition itself.
: I see that either ALTER TABLE or DROP would not work. Can somebody
: please help me with this?
 

: I appreciate any help in advance. It will be more convenient if I can
: get a mail to my e-mail account directly: --

Hopefully you have created your tables by using scripts...

If so, then edit the scripts to first DROP the tables to be changed then recreate them.

 --

_/_/_/_/  _/     _/  _/      _/  _/_/_/  _/_/_/_/   _/_/_/    _/_/_/
_/        _/_/   _/   _/     _/    _/    _/    _/  _/    _/  _/    _/
_/_/_/    _/ _/  _/    _/   _/     _/    _/_/_/    _/        _/    _/
_/        _/  _/ _/     _/ _/      _/    _/        _/        _/    _/
_/_/_/_/  _/   _/_/      /_/     _/_/_/  _/         _/_/_/   _/_/_/
=====================================================================
    Randy DeWoolfson  -  ergo sum    :-)        envipco_at_cais.com
 or Ron Frederick     -  ergo ?      (8P
---------------------------------------------------------------------

#include <StandardDisclaimerOnOpinions> // Null if file not found.

---

Received on Mon May 01 1995 - 00:00:00 CEST