Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between table and view
- 1 Answers
- 3300 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 field in algebra?
What is join query?
what are isolation levels? : Sql server database administration
What is the maximum size per database for sql server express?
What is a scheduled job or what is a scheduled task?
How to write a query with a left outer join in ms sql server?
Why use stored procedures in sql server?
Which is the main third-party tool used in sql server?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How to search for a string in all stored procedure in sql server?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the stored procedure?
-
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)
