Home » Developer & Programmer » Forms » is dropping column supported in 814 db
is dropping column supported in 814 db [message #79994] Wed, 31 July 2002 10:24 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
I'm about to add a column onto an 814 db. I need to be able to drop the column if something fails! Does 814 support the dropping of columns?

Thanks a bunch,
T
Re: is dropping column supported in 814 db [message #80002 is a reply to message #79994] Thu, 01 August 2002 10:19 Go to previous message
Ricardo
Messages: 7
Registered: November 1999
Junior Member
Hi,

The parameter COMPATIBLE of init.ora need value of 8.1.0 or upper.

And to drop a column would you try this:

ALTER TABLE "schema"."table_name"
SET UNUSED ("column_name") CASCADE CONSTRAINTS;

Or:

ALTER TABLE "schema"."table_name"
DROP ("column_name") CASCADE CONSTRAINTS;

But, this value of parameter you can not change already.

Better is drop and create the table with the columns that you need.
Previous Topic: what is ofgtel65.pll library
Next Topic: Report with Columns
Goto Forum:
  


Current Time: Fri Mar 29 00:54:33 CDT 2024