[Cialug] DB2

[David Stout]

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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/cialug/attachments/20050921/4680bb67/attachment-0001.html