SQL Server: alter table, how to add SPARSE definition

Question

I would like alter my table and add SPARSE option to all fields that contain a lot of NULL values. What is the right syntax for this ALTER TABLE command?

Answer 1

The other answers work, but you can also get away with:

ALTER TABLE #foo ALTER COLUMN bar ADD SPARSE;

This way you don't have to look up the column's type or nullability.