difference between table and view in sql code example
Example: table vs view in sql
Table:
It's a table which structured with a
set number of columns and a boundless
number of rows. Table contains data
and stores the data in databases.
Once we change information in data
it changes in the view aswell.
View:
-It's basically a virtual table that
is extracted from a database and views
don't hold data themselves.