The background is that there is a column 'Fn' in a table 'DataProcessed' in SQL Server. Plus, the property of 'Fn' is (varchar(max), NOT NULL).
The problem is that I hope to drop 'Fn' from 'DataProcessed', and free the space which is occupied by 'Fn' in the NDF files of 'DataProcessed'. How can I finish that? Or, is this doable?