Re: How can I drop a column from a table?

henry_at_ix.netcom.com (Hank) wrote:

>>Remember...the modified table is a NEW database object. If you have
>>any access permissions etc. you will need to explicitly assign them to
>>the new table.
>>
>>Ken
>>
 

>Also, don't forget any indexes or especially foreign key constraints
>that may have existed on the original table! (It is easy to forget
>these.) In addition, any views created from the original table will
>need to be recreated or at least re-compilied.
 

> - Hank

Also any foreign key constraints on other tables that references the dropped table !!!!!

Bert van der Meer from Amsterdam,The Netherlands bmeer_at_gak.nl     Received on Wed Jul 31 1996 - 00:00:00 CEST