<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I believe it depends on what version of DB2 if it
is supported. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<LI>Drop the LOCATION column. Also drop any views, indexes, or constraints that
are built on that column. <PRE> <B>ALTER TABLE</B> EQUIPMENT
<B>DROP COLUMN</B> LOCATION <B>CASCADE</B>
<DT> <DT>CASCADE <A name=IDX5203></A><DD>Specifies that any views, indexes, or constraints that are dependent on the column being dropped are also dropped. <P></P><DT>RESTRICT <A name=IDX5204></A><DD>Specifies that the column cannot be dropped if any views, indexes, or constraints are dependent on the column. <P>If all the columns referenced in a constraint are dropped in the same ALTER TABLE statement, RESTRICT does not prevent the drop. </P></DD></PRE></LI></DIV><PRE> </PRE>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ragbrai65@yahoo.com href="mailto:ragbrai65@yahoo.com">David Stout</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=cialug@cialug.org
href="mailto:cialug@cialug.org">cialug@cialug.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 21, 2005 8:58
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Cialug] DB2</DIV>
<DIV><BR></DIV>
<DIV>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?</DIV><BR><BR>David Stout<BR>BTS
Billing Team<BR>Data Repository & Reports
<P>
<HR SIZE=1>
Yahoo! for Good<BR><A href="http://store.yahoo.com/redcross-donate3/">Click
here to donate</A> to the Hurricane Katrina relief effort.
<P>
<HR>
<P></P>_______________________________________________<BR>Cialug mailing
list<BR><A
href="mailto:Cialug@cialug.org">Cialug@cialug.org</A><BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE></BODY></HTML>