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 |
Which sql server table is used to hold the stored procedure scripts?
How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005
Explain a join?
What do you mean by data manipulation language?
What is a performance monitor?
What is a select query statement in ms sql server?
What happens if we shrink log file in sql server?
Which trace flags are enabled in sql server?
What is indexed views? plz explain with example?
Explain the concept of view and Types of views in SQL server?
What is a rownum?
What is the purpose of grouping data in a report?
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)