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

Difference between Table and Views?

Answers (4)