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.
  • M

    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.

Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Popular Tips

X Close