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 |
What is definer in mysql trigger?
How do I quit mysql?
Explain Access Control Lists.
What are the purposes of using enum and set data types?
Does mysql use t sql?
How can I create a database in mysql?
Does mysql automatically index foreign keys?
How to print message in mysql trigger?
What is the purpose of mysql database?
How can you find out the version of the installed mysql?
Write a query to display even rows in student table using mysql?
Can foreign key have duplicate values?
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)