title: How to remove column from a view
body: <p>I am using MS SQL server (2017, Standart Edition-64). I deleted some columns from my DB table, but these columns still appear in table view which is causing me some performance problems. <strong>I need to delete  columns from a view.</strong></p>
  <p>I am aware that there is no DROP COLUMN statement for Views as it is for tables. Also - it seems that ALTER VIEW doesn't offer option to delete columns.</p>
  <p>The View has specific dependencies and triggers, so I can't just simply delete and make a new one. Maybe there is some way to recreate view droping unneeded columns, but  preserving all other properties?</p>