Saturday, 10 October 2015

Difference between question of sql server

Difference between Table and View

Below list is major difference between Table and View in SQL Server;

Table contains Data.
View doesn’t contains data.
Table is physically existence.
View doesn’t physically existence. It’s like virtual table.
You can perform insert, update, delete and Select for it.