Ironically, before modifying a view, we will create another view with a bit more complex T-SQL using aggregates in it rather than having a simple SELECT statement that is pulling everything from a table. A view is based on the result set from a query, and this command allows us to change the structure and definition of a query. The primary goal will be to get familiar with the ALTER VIEW command used to modify views and change the output. In the first write-up so in order to follow along, head over and read the Creating views in SQL Server
We will continue using examples on a sample database and data created In this one, we are moving on and focusing on how to modify views.
In my previous article, we looked at how to use the CREATE VIEW SQL statement to create views.
0 kommentar(er)
