如何查看加密的视图

janny

我在设计视图的过程中，使用WITH ENCRYPTION对视图进行加密。可之后要更改该视图的定义时，却无法查看原视图的内容，请问应该怎样来查看原视图的定义。

[em03]

janny

为什么没有人回答？是能还是不能？

阿罗

老兄你好过分。自己研究BOL不可以啊，上网找资料不可以啊？

The definition of a sensitive view can be encrypted to ensure that its definition cannot be obtained by anyone, including the owner of the view, by using the WITH ENCRYPTION option when the view is created.

--Creating an Encrypted View
CREATE VIEW vwEncrypted
WITH ENCRYPTION
AS
SELECT CompanyName AS C, ContactName AS CN
FROM Customers AS CL

Once the view is created, its definition will be unreadable。 Therefore, make sure that you save your view definition in a script file in case you ever need to modify it

唐小小

臭阿罗

阿罗

以下是引用唐小小在2003-10-10 8:18:22的发言：
臭阿罗

[em03]

阿罗

[em03][em03][em03][em03][em03][em03]