<DIV>
<DIV>There is no Primary or Foreign Key on this column.</DIV>
<DIV>I have the same privileges as admin<BR><BR><B><I>Dave Weis <djweis@internetsolver.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>Try<BR>ALTER TABLE payroll DROP company_id<BR>If it's a key as the name implies it might have constraints from other <BR>tables preventing it from being dropped at all.<BR><BR>On Wed, 21 Sep 2005, David Stout wrote:<BR><BR>> I tryed this<BR>><BR>> ALTER TABLE PAYROLL<BR>> DROP COLUMN COMPANY_ID<BR>><BR>> and got this<BR>><BR>><BR>> Error: SQL0104N An unexpected token "COLUMN" was found following "TABLE PAYROLL DROP". Expected tokens may include: "CONSTRAINT". SQLSTATE=42601<BR>><BR>> (State:42601, Native Code: FFFFFF98)<BR>><BR>><BR>> "Nathan C. Smith" <SMITH@IPMVS.COM>wrote:<BR>> 'Alter table' in SQL?<BR>><BR>> -----Original Message-----<BR>> From: David Stout [mailto:ragbrai65@yahoo.com]<BR>> Sent: Wednesday, September 21, 2005 8:59 AM<BR>> To: cialug@cialug.org<BR>> Subject: [Cialug] DB2<BR>><BR>><BR>> 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?<BR>><BR>><BR>> David Stout<BR>> BTS Billing Team<BR>> Data Repository & Reports<BR>><BR>> ---------------------------------<BR>> Yahoo! for Good<BR>> Click here to donate to the Hurricane Katrina relief effort. _______________________________________________<BR>> Cialug mailing list<BR>> Cialug@cialug.org<BR>> http://cialug.org/mailman/listinfo/cialug<BR>><BR>><BR>> David Stout<BR>> BTS Billing Team<BR>> Data Repository & Reports<BR>><BR>> ---------------------------------<BR>> Yahoo! for Good<BR>> Click here to donate to the Hurricane Katrina relief effort.<BR><BR>-- <BR>Dave Weis<BR>djweis@internetsolver.com<BR>http://www.internetsolver.com/<BR><BR>_______________________________________________<BR>Cialug mailing
list<BR>Cialug@cialug.org<BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE></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.