I have created a simple view
CREATE view v_example
When I add another column to the table in never adds the column to the view - I am always having to drop and recreate it or run sp_refreshview
Is there anything I can add to the view syntax to make sure any changes to the table i.e. columns are updated automatically?