Hi.

When executing the following statement (db2 8.2, Windows 2000 Server):
'alter table table_name drop column column_name'
I get the the SQL-Message SQL0104N 'An unexpected token was found...'.
Does that mean DB2 doesn't allow dropping a column from a table (though the column is empty)?

What can I do to drop a column from a table successfully?

Thank you in advance,
Otfrid

Otfrid Altfeld
Vermittlungstechnik

3U TELECOM AG
Neue Kasseler Straße 62F
D-35039 Marburg

Tel: +49/ (0) 64 21/ 999 - 24 68
Fax: +49/ (0) 64 21/ 999 - 23 45
Email: [Email address protected] <mailto:[Email address protected]
Internet: www.3u.net <http://www.3u.net/>

Jetzt neu: 3U Highspeed-DSL und 3U Internet-Telefonie


DB2 & UDB email list listserv db2-l LazyDBA home page