The better way to do it to look into the code of application and user queries. You should also consider the dependency of the front end applciation which is inserting/updating data into that table. After looking into the applications come out with the list of column not referenced by application. There may be some columns referenced by application but of no relavence or obsolete. In that case you should modify the application first and then modify the database.

What do the expertssay?


Sanjay