deleting a column with some data?

[Guest_imported]

I have tried to delete a column but I always have the following error:

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "escuelaID" was found following "E my_table
DROP". Expected tokens may include: "CONSTRAINT". SQLSTATE=42601

And this is the sql statement that I'm using:
ALTER TABLE my_table DROP escuelaID

I'm on a DB2 system, I'll hope that someone can help me....
Thanks

 

[karluk]

It looks as if DB2 doesn't support dropping columns from existing tables.

 

[HaroldT]

This depends on your version of SQL Server. If you are running SQL 7 then open enterprise manager, go down the tree to the table and right click the mouse on the table. Select table design and open it. Select the field that you want to delete and delete it. Be sure to check for any foreign keys that may be connected to that field. Hope this helps.

 

[Cagliostro]

Hi,
maybe the column is a primary key, and in this case you must drop the key at the first. John Fill

 

[Guest_imported]

Try this..

ALTER TABLE my_table DROP COLUMN escuelaID

May it help you..