How to alter a SQL Server view with a T-SQL script? This code example allows you to modify an existing view. All you must do is use the common ALTER VIEW command. For example, to delete a column from the existing view or to add a column calculated from other columns in the source table.<\/p>\n\n\n\n
Indeed, this example of a T-SQL script allows you to modify an existing view in a Microsoft database.<\/p>\n\n\n\n
For example, to remove the Number of customers column, named NumberCustomers. So that it no longer appears in the list of columns in the new view.<\/p>\n\n\n\n
The SQL Server V_Sales view therefore contains sales data. And the source code of the initial view is available in this article which explains how to create a SQL Server view<\/a><\/strong>. The source code of the view must be executed first to execute the following code without any error.<\/p>\n\n\n\n Execute the following code to alter the view as follows:<\/p>\n\n\n\n In fact, the columns<\/a> are read from the source table. And a view makes it possible to select only the useful data.<\/p>\n\n\n\n Horizontally (with the selected columns) and vertically (with the filter on the data with the SELECT command).<\/p>\n\n\n\n Note that there is a very simple tip to make sure the select in the alter view script works perfectly. The goal is to develop the code view in two steps. <\/p>\n\n\n\n In conclusion, this simple T-SQL example allows you to change the list of columns used in the view.<\/p>\n\n\n\n If necessary, here is a script to perform a SQL Server insert or update also called a SQL Upsert<\/a><\/strong>.<\/p>\n\n\n\nALTER VIEW [dbo].[SalesByMonth] \nAS \nSELECT \n\t[MonthName], \n\t[NumberMonth], \n\tSUM([NumberOfClients]) AS [NumberOfClients], \n\tSUM([Amount_ET]) AS [Amount_ET], \n\tSUM([Amount_IT]) AS [Amount_IT]\nFROM [dbo].[Sales]\nGROUP BY\n\t[MonthName], \n\t[NumberMonth]\nORDER BY\n\tSUM([NumberOfClients]) DESC;\n<\/pre>\n\n\n\n