Encrypting Views

You can encrypt a view.  That is, you can permanently conceal the text of the view definition.

Note   This operation is irreversible.  After you encrypt a view, you can never again modify it, because you can never again see the view definition.  If you need to modify an encrypted view, you must delete it and recreate another one.

To encrypt a view

1. In the SQL Server Enterprise Manager, make sure the Databases node is expanded, and that the node for the target database is expanded, too.
   
   
2. Click the Views node, right-click the target view, then choose Design View from the shortcut menu.
   
   
3. Right-click the background of the Diagram pane and choose Properties from the shortcut menu.
   
   
4. Select Encrypt View and click Close.

See Also

Creating Views