ADD,DELETE,MANAGE FIELDS!!!!!

[maxxx]

How add, delete or change field of table?

If i want to do it i can't do it because there are consrains which don't allow me to do it.

It can be done to delete all schema and make it newerely
using scripts, but i am iteresting is there another method to make such operation?

I know that in Oracle 8i i can do it, but does anybody
know how do it on Oracle 7.3.4???

Please, Help

It is a question of all MY LIFE!!!!!

[Highlander]

The best way to do it in 7.3.4 is to upgrade to 8i

:-)

[carp]

You can ALTER TABLE to add or modify a field. However, prior to 8.1, there is no easy way to delete a field. You have to
CREATE TABLE new_table AS SELECT all_but_the_columns_you_want_to_drop;
Drop the table after disabling any foreign key constraints.
RENAME new_table TO old_table.
Recreate indexes, constraints.