Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

SQL: Alter Views

Posted on February 23, 2021 By rich No Comments on SQL: Alter Views

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.

Alter table - Table before script executed
See Creating Views to see the view created before this was run.


USE TechShizz
GO

ALTER VIEW vEmployeesWithSales
AS

    SELECT DISTINCT
        Employees.EmployeeID,
        FirstName,
        LastName
    FROM
        Employees
            JOIN
        Sales ON Employees.EmployeeID =Sales.EmployeeID

GO


Next we can re-name the view by using the following command:

sp_rename ‘vEmployeesWithSales’,’Employees’

Once renamed and altered the table should look like this once executed:

Alter table - Table after script executed


Another Example

We could alter the view so that we have a view for the entire Emplyees table.
USE TechShizz
GO

ALTER VIEW vEmployees
AS

    SELECT DISTINCT
        *
    FROM
        Employees
GO

Alter table - Table after 2nd script executed

Post navigation

❮ Previous Post: SQL: Information on SQL Server Editions and Features
Next Post: SQL: Create a Database ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown