Difference between View and table in sql

Question

Possible Duplicate    Difference Between Views and Tables in Performance       What is the main difference between view and table in SQL  Is there any advantage of using views instead of tables

User · Answer

Table  Table is a preliminary storage for storing data and information in RDBMS  A table is a collection of related data entries and it consists of columns and rows   View   A view is a virtual table whose contents are defined by a query  Unless indexed  a view does not exist as a stored set of data values in a database  Advantages over table are   We can combine columns rows from multiple table or another view and have a consolidated view  Views can be used as security mechanisms by letting users access data through the view  without granting the users permissions to directly access the underlying base tables of the view It acts as abstract layer to downstream systems  so any change in schema is not exposed and hence the downstream systems doesn t get affected

User · Answer

Table   Table stores the data in database and contains the data   View   View is an imaginary table  contains only the fields columns  and does not contain data row  which will be framed at run time Views created from one or more than one table by joins  with selected columns  Views are created to hide some columns from the user for security reasons  and to hide information exist in the column  Views reduces the effort for writing queries to access specific columns every time Instead of hitting the complex query to database every time  we can use view

User · Answer

A table contains data  a view is just a SELECT statement which has been saved in the database  more or less  depending on your database    The advantage of a view is that it can join data from several tables thus creating a new view of it  Say you have a database with salaries and you need to do some complex statistical queries on it   Instead of sending the complex query to the database all the time  you can save the query as a view and then SELECT   FROM view

User · Answer

A view is a virtual table  A view consists of rows and columns just like a table  The difference between a view and a table is that views are definitions built on top of other tables  or views   and do not hold data themselves  If data is changing in the underlying table  the same change is reflected in the view  A view can be built on top of a single table or multiple tables  It can also be built on top of another view  In the SQL Create View page  we will see how a view can be built       Views offer the following advantages          Ease of use  A view hides the complexity of the database tables from end users  Essentially we can think of views as a layer of abstraction on top of the database tables    Space savings  Views takes very little space to store  since they do not store actual data    Additional data security  Views can include only certain columns in the table so that only the non-sensitive columns are included and exposed to the end user  In addition  some databases allow views to have different security settings  thus hiding sensitive data from prying eyes       Answer from http   www 1keydata com sql sql-view html

User · Answer

In view there is not any direct or physical relation with the database  And Modification through a view  e g  insert  update  delete  is not permitted Its just a logical set of tables

User · Answer

A view helps us in get rid of utilizing database space all the time  If you create a table it is stored in database and holds some space throughout its existence  Instead view is utilized when a query runs hence saving the db space  And we cannot create big tables all the time joining different tables though we could but its depends how big the table is to save the space  So view just temporarily create a table with joining different table at the run time  Experts Please correct me if I am wrong

User · Answer

SQL Views   View is a virtual table based on the result-set of an SQL statement and that is Stored in the database with some name   SQL Table   SQL table is database instance consists of fields  columns   and rows    Check following post  author listed around seven differences between views and table   https   codechef4u com post 2015 09 03 sql-views-vs-tables

[sql] Difference between View and table in sql

Examples related to sql

Examples related to view