Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between table and view
- 1 Answers
- 3374 Views
- I also Faced
- E-Mail Answers
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 TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
what is an index? : Sql server database administration
How to make a column nullable?
What are trace flags and mention a few common trace flags used with sql server?
What number sorts of privileges are accessible in sql?
What is Command line parameters in PLSQL.?
What is join query?
What is difference between view and materialized view?
What is the default server name for sql server?
Explain table valued parameters in sql server? Why tvp used?
What are the different authentication modes in sql server?
-
Oracle (3253) - 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)
