Encrypting Views

      Using 'SP_HELPTEXT' (SP_HELPTEXT <View name>)we can see the view code. If we create a view with "WITH ENCRYPTION" then we can't see the view code.

Example:

Sample Employee Table creation with data

Sample Department table creation with data

View Creation Script:

CREATE VIEW EMPLOYEE4

WITH ENCRYPTION

AS

SELECT A.ID

      ,A.FirstName

      ,A.LastName

      ,A.Gender

      ,A.Dept_ID

      ,B.Name

      ,B.Location

FROM EMPLOYEE A

JOIN DEPT B 

ON A.Dept_ID = B.DeptID

Checking view source code: 
     If we try to view the view code it will through the message.

SP_HELPTEXT EMPLOYEE4