Re: [Q] How do I drop a column from a table?
From: ME <74577.1525_at_CompuServe.COM>
Date: 1996/12/10
Message-ID: <58k94f$3f1$3_at_mhadf.production.compuserve.com>#1/1
Date: 1996/12/10
Message-ID: <58k94f$3f1$3_at_mhadf.production.compuserve.com>#1/1
<<
Hi! Unfortunately, you can't drop columns from tables. You can rename a
table and then create a new without the column with the old name but
then you will lose your triggers. >>
This is what makes CAD so nice... export the table, drop/re-create it,
import the data. CAD programs also store the triggers for the table,
so they get recreated as well...Also makes handling of any foreign keys
easier and the create table statement is done for you! <grin>
Robert Received on Tue Dec 10 1996 - 00:00:00 CET