Answer Posted / Amit Kumar Gupta
The main differences between a table and a view in SQL Server are:
1. Tables store data, while views only contain virtual tables derived from one or more existing tables.
2. Tables can be directly manipulated (INSERT, UPDATE, DELETE), whereas views cannot.
3. Tables have a physical representation on disk, while views do not.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is spatial nonclustered index
What are wait types?
Equi join and non equi join is possible with sql server?
How to rebuild the master database?
Why should you use or avoid select * statements?
How to connect php with different port numbers?
What is the difference between for xml raw and for xml auto?
What is self contained sub query?
What is normalization and what are the advantages of it?
Explain “row_number()” in sql server with an example?
Can we shrink data file in sql server?
What is the primary use of the model database?
How efficient you are in oracle and SQL server?
Why we use the openxml clause?
List the ways in which dynamic sql can be executed?
