What is the difference between a Table and a View?
Answers were Sorted based on User's Feedback
Answer / guest
Table contains all the row. View doesn't contain any data
but rather an SQL statement that is executed every time the
View is accessed. It provided row level security for
accessing information.
The downside is lost performance as compared to a Table
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / jagdish prajapati
Table is Physical Stored. but View is logical or virtual
Stored.
| Is This Answer Correct ? | 9 Yes | 1 No |
How can we know the number of days between two given dates using MySQL?
2 Answers Base2 Infotech, Webworks,
How can I see connections in mysql?
What is a join in mysql?
What is the insert?
How to copy data from one server to another using php?
What is a deterministic function?
How do I rename a mysql database?
What is 'mysqld'?
How to analyze tables with 'mysqlcheck'?
What is the data type for file in mysql?
What is view in mysql?
What is pragma autonomous_transaction?
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)