Sql Server Programming :: Create view


	Create view Hi. I created a view and I compiled, changed from Create to Alter. Every time close it and re-open it opens as Create instead of Alter. Any thoughts? Use script to be run in QA instead of using EM "ITDUDE27" <ITDUD@discussions.microsoft.com> wrote in message news:562F9487-5B5A-468A-AF58-B548BCB6CDDF@microsoft.com... - Hide quoted text - > Hi. > I created a view and I compiled, changed from Create to Alter. Every time > close it and re-open it opens as Create instead of Alter. > Any thoughts? Are you using Management Studio? How do you re-open your view? -- Martin Poon \| Microsoft MVP (SQL Server) http://msmvps.com/blogs/martinpoon -- "ITDUDE27" <ITDUD@discussions.microsoft.com> wrote in message news:562F9487-5B5A-468A-AF58-B548BCB6CDDF@microsoft.com... - Hide quoted text - > Hi. > I created a view and I compiled, changed from Create to Alter. Every time > close it and re-open it opens as Create instead of Alter. > Any thoughts?