Deleting field/columns from an existing SQL tablegreenspun.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.
-- Anonymous, April 19, 2000
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,
-- Anonymous, April 20, 2000