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 |
How to write a script for upate the data in prod , i have 50000 row are there
How to insert and update data into a table with "insert" and "update" statements?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are ddl (data definition language) statements for tables in ms sql server?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is wide table?
How do I create a trace in sql server?
Explain Different types of Projects?
How do I find the sql server database version?
How to make a remote connection in a database?
What is change data capture (cdc) in sql server 2008?
What are the two virtual tables SQL Server maintains for triggers?
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)