22、数据库对象操作全解析

数据库对象操作全解析

1. 视图操作

1.1 创建和修改视图

创建视图时可以使用加密选项，例如创建一个名为 dbo.vMarketingEmployees 的视图：

CREATE VIEW dbo.vMarketingEmployees
WITH ENCRYPTION
AS
SELECT dbo.Employee.EmpFirstName AS FirstName,
       dbo.Employee.EmpLastName AS LastName,
       dbo.Department.DepartmentDscr AS Department  
FROM dbo.Department INNER JOIN
     dbo.Employee ON  
       dbo.Department.DepartmentID = dbo.Employee.DepartmentID  
WHERE dbo.Department.DepartmentID = 1

若发现市场部门的 DepartmentID 实际为 2，且想移除加密选项，可以使用 ALTER VIEW 语句进行修改：

USE AdventureWorks2008R2  
GO
ALTER VIEW dbo.vMarketingEmployees
AS
SELECT dbo.Employee.EmpFirstName AS FirstName,