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 |
What is normalization of database?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
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
What is primary key and example?
What is difference between table aliases and column aliases? Do they affect performance?
Mention the differences between having and where clause.
How to find Duplicate Records In table?
What is indexed views? plz explain with example?
What is bit data type?
Explain datetime2 data type in sal server 2008?
What are sql servers used for?