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 the maximun sixes of .mdf in sql server 2005
what is nonclustered index
Explain sql delete command?
how can i store resumes in database?
Define inner join? Explain with an example?
What is index fragmentation in ms sql server?
Explain the concept of view and Types of views in SQL server?
How can you hide the sql server instances?
How do you persist objects, permissions in tempdb
What are the diifferences between the ms sql server vs mysql?
How to encrypt Strored Procedure in SQL SERVER?
What do you mean by sql server 2005 express management tools?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)