what is the difference between table and view



what is the difference between table and view..

Answer / ashok

1.If we create a table it will save in database but a view is a virtual image there is no physical existance.
2. We can use order by clause in tables but views does not support order by clause.
3.In a view we can specify only a select statement inside a view but in tables we use all dml,ddl statements.
4.If we updating a base table using view which contains joins may not update correctly,but in tables we can update using joins.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is normalization of database?

0 Answers  


Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  


Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  


One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  


What is primary key and example?

0 Answers  






What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  


Mention the differences between having and where clause.

0 Answers  


How to find Duplicate Records In table?

0 Answers   HCL,


What is indexed views? plz explain with example?

2 Answers  


What is bit data type?

0 Answers  


Explain datetime2 data type in sal server 2008?

0 Answers  


What are sql servers used for?

0 Answers  


Categories