[Cialug] DB2

[Dave Weis]

Try
ALTER TABLE payroll DROP company_id
If it's a key as the name implies it might have constraints from other 
tables preventing it from being dropped at all.

On Wed, 21 Sep 2005, David Stout wrote:

> I tryed this
>
> ALTER TABLE PAYROLL
> DROP COLUMN COMPANY_ID
>
> and got this
>
>
> Error: SQL0104N An unexpected token "COLUMN" was found following "TABLE PAYROLL DROP". Expected tokens may include: "CONSTRAINT". SQLSTATE=42601
>
> (State:42601, Native Code: FFFFFF98)
>
>
> "Nathan C. Smith" <smith at ipmvs.com> wrote:
> 'Alter table' in SQL?
>
> -----Original Message-----
> From: David Stout [mailto:ragbrai65 at yahoo.com]
> Sent: Wednesday, September 21, 2005 8:59 AM
> To: cialug at cialug.org
> 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
>
>
> David Stout
> BTS Billing Team
> Data Repository & Reports
>
> ---------------------------------
> Yahoo! for Good
> Click here to donate to the Hurricane Katrina relief effort.

-- 
Dave Weis
djweis at internetsolver.com
http://www.internetsolver.com/