In this example, we alter a view so that instead of dislpaying all colums in the Employees table, we now only show the EmployeeID, FirstName and LastName. This is specified under the “SELECT DISTINCT” part.
Here is the View before the following script is executed.
See Creating Views to see the view created before this was run.
ALTER VIEW vEmployeesWithSales
Sales ON Employees.EmployeeID =Sales.EmployeeID
Next we can re-name the view by using the following command:
Once renamed and altered the table should look like this once executed:
We could alter the view so that we have a view for the entire Emplyees table.
ALTER VIEW vEmployees