Pavan Ramamurthy
Difference between Table and Views ?
By Pavan Ramamurthy in Software Testing on Jul 06 2015
  • Mahesh Gawhane
    Dec, 2015 3

    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 this 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

    • 4
  • Pankaj  Kumar Choudhary
    Aug, 2015 28

    Views are virtual tables which hold the data from one or more tables. It is stored in database. View does not contain its self any data, it is a set of queries that are applied to one or more tables that is stored within the database as an object. Where as Table are stored physically in database that contain rows and columns, columns representing

    • 3
  • Sofique Uddin
    Jan, 2017 4

    Table is a basic unit of data storage in an oracle database. It holds all user accessible data.View is a virtual table - It can be created on a table or another view. - It is just like a window through which we can access or change base table data. - It does contain data of its own. It always takes data from its base table. - It is stored as a query in data dictionary.Whenever you query a view it gets data from its based table using this query.Main advantage of using views - You can ristrict access to predetermined set of rows and columns of a table - You can hide complexity of query - You can hide complexity of calculationSynonym is alternate name given to table, view, sequence or program unit. -It is used to mask real name and owner of the object. - You can provide public access to tables by creating public synonymns.

    • 2
  • Irdi Buzali
    Aug, 2016 17

    tables contains records with data. Views are looking as table query. For example: if u wish to show only last 5 rows in a table, you can create a view ( for example 'view1' ) with query as below:select top 5 * from table order by id descAlways you like to show last 5 records, you can open the view. Also you can treat the view as table, so you can query to views created before. For example:select top 2 * from view1

    • 2
  • Deepak Rawat
    May, 2023 8

    Data Visibility:

    Table: When testing tables, you directly access and manipulate the actual data stored in the table. You can perform CRUD operations (Create, Read, Update, Delete) on the table’s data.
    View: When testing views, you interact with the data presented by the view rather than the underlying tables. Views act as a filtered or transformed representation of the data, so you need to ensure that the view correctly displays the expected data based on the underlying tables.
    Data Modification:

    Table: As a tester, you may need to perform data modifications during testing, such as inserting test data, updating records, or deleting data. Tables allow you to directly perform these modifications.
    View: Views are generally read-only, which means you cannot directly modify the data through a view. If you need to modify the data, you would need to identify the underlying table(s) associated with the view and perform the necessary modifications on the table(s).
    Data Validation:

    Table: When testing tables, you can verify the data integrity and consistency by comparing the actual data in the table with expected values or predefined business rules. You can also validate constraints and relationships defined on the table.
    View: Testing views involves ensuring that the data presented by the view is accurate and aligned with the expected results based on the underlying tables and any filtering or transformation logic applied in the view’s definition.
    Query Testing:

    Table: When testing tables, you may need to write and execute SQL queries directly on the table to fetch specific data for testing purposes or to validate complex business scenarios.
    View: Testing views involves writing and executing SQL queries against the view to validate the correctness of the view’s logic, data filtering, or transformation. You need to ensure that the query results from the view align with the expected results.

    • 1
  • Venkateswaran S
    Mar, 2017 9

    Set of rows/columns is table if we want to view a duplicate copy of column name that is a view

    • 1
  • Keerthi Venkatesan
    Jun, 2016 8

    Table is collection of data which contain Column and row. View is a virtual table which use to create web API.

    • 1
  • Sandeep Kumar
    Dec, 2015 21

    Table is collection of data which contain Column and row. View is a virtual table which use to create web API.

    • 1
  • Jez Supreme
    Jun, 2022 7

    The main difference between view and table is that view is a virtual table based on the result set of an SQL statement, while the table is a database object which consists of rows and columns that store data of a database. In brief, a programmer cannot create views without using table.

    steps in a wrongful death lawsuit

    • 0
  • Sanjeev Kumar
    Jul, 2016 19

    1>table can create individually but view can not create individually view depends one table or more than one table 2> table can call compile time and run time data and view can call only run time 3>table is performance wise slower and view is faster

    • 0
  • Keerthi Venkatesan
    Jun, 2016 8

    Table is collection of data which contain Column and row. View is a virtual table which use to create web API.

    • 0
  • Nikhil Sangani
    Jun, 2016 6

    view is a virtual table based on the result-set of an SQL statement.A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.TABLE is a normal real time table which really hold data in the database.

    • 0
  • Bhuvanesh Mohankumar
    May, 2016 18

    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).

    • 0
  • Ashish Srivastava
    Jan, 2016 9

    Table is an object of an database which contains data inside. where as views are used to retrieve data from table or to display data in such manner.we can use select , insert update and delete operation in table but in view only select

    • 0
  • Kml Surani
    Dec, 2015 21

    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 this 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

    • 0
  • Ayyaz Ahmad
    Dec, 2015 19

    table contains data of same record but view can be said as virtual table can contain data from different table table same syntax of Select use for selction

    • 0
  • Chinmaya Dash
    Dec, 2015 1

    Table is an object of an database which contains data inside. where as views are used to retrieve data from table or to display data in such manner.

    • 0
  • Ayyaz Ahmad
    Nov, 2015 22

    Table is a simple representation of out entity but view is virtual table that can contain data from different tables

    • 0
  • Ramakrishna Basagalla
    Nov, 2015 12

    Tables are the primary source to feed data, views are virtual tables created on tables, views are mainly used to restrict the data to display.

    • 0
  • Sreekanth Reddy
    Nov, 2015 2

    -->It's a virtual table. -->Stores the data more than one tables information as columns. -->Insertion into views will effect the main table.

    • 0
  • Bhushan Bhasme
    Oct, 2015 4

    we can say view can be virtual table and it can be handle to a table without any where clause in the query of view.

    • 0
  • Sudheshwer  Rai
    Sep, 2015 21

    Table - It has to be physically existence in database with rows and columns.View - It has to be logically/virtually existence in database with rows and columns.

    • 0
  • Sujeet Suman
    Sep, 2015 2

    Table & view both having row-column format but difference is that table having physical data where as view not.

    • 0
  • Munesh Sharma
    Aug, 2015 5

    Table comprises of rows and columns, columns representing fields and rows containing the data or records. View is a imaginay table which contains data at run time.

    • 0
  • Sonia Chugh
    Jul, 2015 31

    table is a collection of rows and columns but view is a virtual table like a table that contain rows and columns but does't contain any type of data in it

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS