Multiple Column Drop

[BDRichardson]

Hi,

Would anyone kindly clarify for me whether it is fact possible or not to drop multiple columns from a SQL Server 2000 table? If, so how?

The SQL Server 2000 Online book implies that its possible by the [,...n] syntax after ALTER TABLE table DROP COLUMN column

 

[bborissov]

Yes it is:

Create table #test (Fld1 Int, Fld2 Int, Fld3 Int)
SELECT * from #test
ALTER TABLE #Test DROP COLUMN Fld2, Fld3
SELECT * from #test
DROP TABLE #test

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[BDRichardson]

Doh! ... I must be going mad!

Thanks for setting me straight!

 

[bborissov]

LOL

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.