Re: Dropping fields from table description ?

From: Greg Tupper <gtupper_at_monkfish.nosc.mil>
Date: Fri, 25 Feb 1994 07:59:43 GMT
Message-ID: <1994Feb25.075943.4870_at_nosc.mil>

The only way I know is to create a temp table selecting all the colums you wish to keep, dropping the original table, and renameing the replacement. Be sure any views are modified to not select from the missing columns. Also grants will need to be remade.

Check out the FAQ as there is an excellent scripts for recreating tables. The intermediate file could be edited to drop the colum. The script also takes care of the grants.

Greg Tupper
SAIC Comsystems
gtupper_at_nosc.mil Received on Fri Feb 25 1994 - 08:59:43 CET

This message: [ Message body ]
Next message: Frank Green: "Re: Dropping fields from table description ?"
Previous message: jl34778_at_corp02.d51.lilly.com: "Re: Extract table data to file in ascii format"
In reply to: J. Keith Alston: "Dropping fields from table description ?"
Next in thread: Frank Green: "Re: Dropping fields from table description ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message