python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
case in sql server 2008 r2

What is SQL view? Why use View instead of a Table? Advantages and Drawbacks

What is SQL view?
The View is a virtual table, which not create physically, it create logically only. We insert, update & delete the records from a view.

In view there are no any physical relations in the database and the view is a virtual table based on the result set of an SQL statement.

Why use View instead of a Table?
A table contains data but the View dose not stored set of data values in a database and the view is only a SELECT statement.

A view can combine columns/rows from multiple tables.

Views are work like a security layers and we can handle security issues.

Views can be used as security mechanisms and its display only those data that you granting the permissions in this view.

Advantages of View:-
We can hide so of table columns.

Views can model complex joins easily.

Views are work like a security layers and we can handle security issues.

Drawbacks of View: -
When table is dropped or modified, view becomes inactive; it depends on the table objects.

If we querying from views, it will takes more time than directly querying from the tables.

We can lose information about relations (primary, foreign keys).

How to create View “Virtual Table”?

Syntax:-
-- CREATE VIEWS
CREATE VIEW View_Name 
AS
    SELECT Column_Name
    FROM Table_Name
WHERE your_Conditions

Example for Create View:-
-- CREATE ACTIVE CUSTOMERS VIEWS
CREATE VIEW vw_Active_Customers
AS
    SELECT Id, Name, CreatedOn, UpdatedBy
    FROM [dbo].[Customer]
WHERE IsCurrent =  1


-- SELECT ACTIVE CUSTOMERS VIEWS
SELECT * FROM [dbo].[vw_Active_Customers]


-- DROP VIEW 
DROP VIEW [dbo].[vw_Active_Customers]
ANIL SINGH

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions