Home -> Usenet -> c.d.o.tools -> Re: how can I drop a column from a table??? Hurry up, please

Re: how can I drop a column from a table??? Hurry up, please

From: <tomscott_at_nospam.abac.com>
Date: 1998/09/15
Message-ID: <35fe629a.229415068_at_news1.abac.com>#1/1 







    
  
  1.   Find all the constraints for the table and disable/inactivate them
  
  2.   Rename the table
  
  3.   Create a new table with only the columns you want
  
  4.   Lod the new table from the renamed table with a select statement
  
  5.   Reenable the constraints






Sad, but true.



There are scripts out there that will do this for you, but it's not
that difficult to do yourself.
Received on Tue Sep 15 1998 - 00:00:00 CEST












Original text of this message