[Cialug] DB2

[Jon Clemons]

I believe it depends on what version of DB2 if it is supported. 


a.. Drop the LOCATION column. Also drop any views, indexes, or constraints that are built on that column. 
   ALTER TABLE EQUIPMENT
     DROP COLUMN LOCATION CASCADE
CASCADE Specifies that any views, indexes, or constraints that are dependent on the column being dropped are also dropped. RESTRICT Specifies that the column cannot be dropped if any views, indexes, or constraints are dependent on the column. If all the columns referenced in a constraint are dropped in the same ALTER TABLE statement, RESTRICT does not prevent the drop. ----- Original Message ----- 
  From: David Stout 
  To: cialug at cialug.org 
  Sent: Wednesday, September 21, 2005 8:58 AM
  Subject: [Cialug] DB2


  I need a little help does anyone know If you can delete a column from a table in DB2. If so what is the syntax?


  David Stout
  BTS Billing Team
  Data Repository & Reports


------------------------------------------------------------------------------
  Yahoo! for Good
  Click here to donate to the Hurricane Katrina relief effort. 


------------------------------------------------------------------------------


  _______________________________________________
  Cialug mailing list
  Cialug at cialug.org
  http://cialug.org/mailman/listinfo/cialug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/cialug/attachments/20050921/e9919c7b/attachment.htm