[Cialug] DB2

[David Stout]

There is no Primary or Foreign Key on this column.
I have the same privileges as admin

Dave Weis <djweis at internetsolver.com> wrote:

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" 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/

_______________________________________________
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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/cialug/attachments/20050921/dbb692a2/attachment.htm