Difference between VIEW vs TABLE.

Question

Anubhav Sharma · Answer

TABLE A physical object that stores actual data in the databaseData is persisted on diskSupports INSERT, UPDATE, DELETECan have indexes, constraints, keys Example: VIEW A virtual table based on a SQL queryDoes not store data (stores only the query)Data is fetched dynamically from underlying tablesMostly used for security, abstraction, and reuse Example: Key Differences Feature TABLE VIEW Storage Stores data physically No physical data storage Type Real object Virtual object Data Source Direct From one/more tables DML Support Full (Insert/Update/Delete) Limited (depends on view) Performance Faster (direct access) Slower (query execution) Use Case Data storage Data abstraction/security Simple Analogy TABLE → Like a database file (actual data)VIEW → Like a saved query/report When to Use Use TABLE when: You need to store dataPerform CRUD operations Use VIEW when: You want to simplify complex queriesRestrict access to specific columnsCombine multiple tables into one logical view Final Thought TABLE = Data StorageVIEW = Data Representation

Feature	TABLE	VIEW
Storage	Stores data physically	No physical data storage
Type	Real object	Virtual object
Data Source	Direct	From one/more tables
DML Support	Full (Insert/Update/Delete)	Limited (depends on view)
Performance	Faster (direct access)	Slower (query execution)
Use Case	Data storage	Data abstraction/security

interview

Difference between VIEW vs TABLE.

Can you answer this question?

1 Answers

TABLE

VIEW

Key Differences

Simple Analogy

When to Use

Final Thought