Benefits of Views

Many benefits are associated with the use of views. Here’s a summary of these benefits: Using views, users don’t query the tables directly; therefore, you are creating a security layer between users (or applications) and base tables. This, in turn, has another benefit: If the underlying database schema changes, you don’t have to change the [...]

Read Full Post »

WITH ENCRYPTION,WITH SCHEMABINDING Features in View

With Encrypton: The definition of view can be seen by any user after the view is crated using sp_helptext or using syscomments system table, To avoid this we can create the view using With Encryption option. Ex: USE Northwind GO CREATE VIEW LondonEmployees WITH ENCRYPTION AS SELECT * FROM employees WHERE city    = ‘london’ GO [...]

Read Full Post »