title: create view with select *
body: <p>I've created a view with <code>CREATE VIEW dbo.myView AS SELECT * FROM dbo.myTable</code>. <code>myView</code> does not select new columns when I add columns to <code>dbo.myTable</code>.  Is there a way I can make my view select all columns from a table even after I add columns without having to update the view?</p>