Difference between Table and Views?

Question

Riya Patel · Answer

Tables store actual data in the database, while Views are virtual tables that show data from one or more tables without storing it themselves. Views are used to simplify complex queries or hide specific columns for security.

Nitin Pandit · Answer

A table is a physical structure within a database that stores data in rows and columns, while a view is a virtual table that provides a simplified or customized presentation of data from one or more underlying tables.

Alpesh Maniya · Answer

A table stores the actual data, while a view is the combination of one or more tables logically. It simplifies the use and security. if we don't want to expose the columns directly from the table, then we can prepare the view, and it will be accessible in the same way as the table.

Sangeetha S · Answer

Table : A table is a database object that stores data in rows and columns. It is a physical structure that holds actual data. View : A view is a virtual table based on the result of a SQL query. It does not store data itself but displays data stored in one or more tables. CREATE VIEW IT_Employees AS SELECT Name FROM Employees WHERE Department = 'IT'; CREATE TABLE Employees ( ID INT, Name VARCHAR(100), Department VARCHAR(50) );

Kritika · Answer

In a database, a table is like a container where actual data is stored. It has rows and columns, like an Excel sheet. You can add, change, or delete data in a table directly. A view, on the other hand, is not a real table. It just shows data from one or more tables, based on a saved query. Views are helpful when you want to see only part of the data or want to make complex queries easier. You can use a view like a table, but you usually can’t change data through a view. Table: Stores real data You can add, edit, or delete data Like a regular Excel sheet with complete data Data is saved in the database View: Shows data from a table (or many tables) Does not store actual data Used to show selected or filtered data Good for making complex data easy to understand

Difference between Table and Views?

Answers (5)