Alter table drop column ?!?

[Gert-Jan Hiddink]

Hi,

By using ODBC I thought I could fullfill my needs with a single script which
would work with several database engines. One of the 'needs' I have is to
alter databases; since the 'alter table' command can be found in the SQL '92
standard, I figured that it would be supported by most database engines.
Wrong.
I am able to add and drop columns to/from a Access database, but the same
command is rejected by sql-server 6.5. I can add a column to a sql-server
database, but I CANNOT drop it...
Does anyone know how I can deal with this problem?

The only way I found that always worked was to rename the table and then
create a new one with the desired definition and then copy the data back in.
I don't find this is a solution...

Gert-Jan Hiddink

RepIT BV
The Netherlands
g...@repit.com

[Bob Pfeiff]

Unfortunately, the solution you describe is the only one in SQL 6.5.

You can drop columns in SQL 7.
--
Bob Pfeiff
SQL Server MVP