View Options
When you create or alter a view, you can specify options that will control the view’s behavior and functionality. The options ENCRYPTION, SCHEMABINDING, and VIEW_METADATA are specified in the view’s header, and the CHECK OPTION is specified after the query.
ENCRYPTION
The ENCRYPTION option is available for views, UDFs, stored procedures, and triggers. If you don’t specify the ENCRYPTION option, SQL Server stores the text defining the body of the object/routine as clear text in sys.sql.modules (or in syscomments in SQL Server 2000). If you specify the ENCRYPTION option, the object’s text will be converted to an obfuscated format. But don’t rely on this option as an encryption mechanism to protect your intellectual property. People have ...
Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
