Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / what are the uses of view?
Ask Question
Shrikant Mishra
Shrikant Mishra

Content Writer

I'm a professional writer and Business Development with more than 10 years of experience. I have worked for a lot of businesses and can share sample works with you upon request. Chat me up and let's get started.

Message

1 Answers

Rahul Roi
Rahul Roi 03 Nov 2020
Report Abuse

If we are discussion about the role of views in SQL server then founded that it is kind of virtual tables.

A view has also some rows and columns as they are in a real table in the database.

We can also create a view by selecting fields from one or more tables present in the database.

Where a view can either have all the rows of a table or specific rows based on certain condition.

And where the VIEW in SQL is a logical subset of data from one or more tables. And mostly, the view is used to restrict data access.

  • The role of Views is - It can be represent a subset of the data contained in a table; with the result that a view can limit the degree of unveiling of the underlying tables to the outer world.
  • When the listed users may have permission to query the view, And while denied access to the rest of the base table.
  • And A views can join and simplify multiple tables into a single virtual table.
  • A views can enactment as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data
  • Where a view can hide the complexity of data; for the example, the view could appear as Sales1001 or Sales2001, transparently partitioning the actual underlying table
  • In the views, It takes a very little space to store the data in SQL server; And the database contains only the definition of a view, not a copy of all the data which it presents.
  • The Views may provide additional security, depending on the SQL engine used.
Syntax for creating a View,

CREATE or REPLACE VIEW view_name 

    AS

    SELECT column_name(s)

    FROM table_name

    WHERE condition
advertising