Re: Deleting fields

Hi Anthony,

I think what you need to do is to write an Oracle script file (*.sql) with the commands creating a new table with the desired columns from the old table and delete the old table.

For example, if the old table has columns col1, col2 and col3 and you want to drop col3. Then the commands might be:

create table <newtable> as select col1, col2 from <oldtable>; drop table <oldtable>;

Romy

Anthony D'Cruze wrote in message <364713ec.0_at_195.182.170.1>...
>I am working on a system where I have a developer database and whenever I
>make changes to the database I send the *.SQL file to the administrator of
>the live one.
>
>What I need to do is to delete a field from a table.
>
>Can any one help with the SQL.
>
>
>
Received on Tue Nov 17 1998 - 10:25:42 CET