Deleting field/columns from an existing SQL table

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I am working to set up a datawarehouse using either SQL Server 6.5 or 7.0, most likely 7.0. The data will be imported from a Unisys mainframe system. The problem I am running into is that there are times when the programmers of the mainframe will decide to either add or delete a field from a table. To me this causes a problem as I have not yet found a way to delete a single field from a table in SQL Server 6.5 and am not sure if one exists in 7.0. Any help you can offer would be appreciated.

Jim

-- Anonymous, April 19, 2000

Answers

James,

Both the 6.5 and 7.0 versions support adding a column to a table. But, you are right that SQL Server 6.5 does not support column deletion. SQL 7.0 does.

Hope this helps,

Eric

-- Anonymous, April 20, 2000


Moderation questions? read the FAQ