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. See the Reference Manual: Procedures and “Compiled objects”.
