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 are the different types of replication you can set up in sql server?
How to transfer data from a cursor to variables with a "fetch" statement?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
Explain about integration services of Microsoft SQL server?
Does the unique constraint create an index?
How to link up the text file to a Database table?
What is a mutating table error and how can you get around it?
What are a scheduled jobs or what is a scheduled tasks?
What is difference between cte and view?
What are the different types of locks in the database?
what is a deadlock? : Sql server database administration
How do I view a script in sql server?
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)