<DIV>I tryed this </DIV>
<DIV> </DIV>
<DIV>ALTER TABLE PAYROLL<BR>DROP COLUMN COMPANY_ID</DIV>
<DIV> </DIV>
<DIV>and got this</DIV>
<DIV> </DIV>
<DIV><FONT size=2>
<P>Error: SQL0104N An unexpected token "COLUMN" was found following "TABLE PAYROLL DROP". Expected tokens may include: "CONSTRAINT". SQLSTATE=42601</P>
<P>(State:42601, Native Code: FFFFFF98)</P></FONT><BR><BR><B><I>"Nathan C. Smith" <smith@ipmvs.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR>
<DIV><SPAN class=106010214-21092005><FONT face=Arial color=#0000ff size=2>'Alter table' in SQL?</FONT></SPAN></DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> David Stout [mailto:ragbrai65@yahoo.com] <BR><B>Sent:</B> Wednesday, September 21, 2005 8:59 AM<BR><B>To:</B> cialug@cialug.org<BR><B>Subject:</B> [Cialug] DB2<BR><BR></FONT></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. _______________________________________________<BR>Cialug mailing list<BR>Cialug@cialug.org<BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE><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.