After you create a view, the source text describing the view is stored in the text column of the syscomments system table. Do not remove this information from syscomments. Instead, encrypt the text in syscomments by using sp_hidetext, which is described in the Reference Manual. For more information, see “Compiled objects”.
