What is the difference between VIEW and TABLE in SQL Server?
Dung Do Tien
Oct 19 2020
329
What is the difference between VIEW
and TABLE
in SQL Server?
Please explain to me if you know the difference between them.
Have 1 answer(s) found.
-
M0
Marry Christ Oct 19 2020
Some feature below is the difference between VIEW and TABLE in SQL Server:
1. VIEW
- Not store data.
- Can return data from many tables.
- It's read-only, it can not insert, update, delete data.
- It's helpful to make a report.
2. TABLE
- It's help store data
- Can manage data with insert, update, delete data.
* Type maximum 2000 characters.
* All comments have to wait approved before display.
* Please polite comment and respect questions and answers of others.