What is the difference between a Table and a View?

Answer Posted / shaik

-Table will have its own data,View doesnt have its own data.

-In Tables data stored Physically,In view its logiacally.

-we have tables of single type,but in views, Simply and
complex views.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we rollback truncate in mysql?

515


How to enable or disable a row of a table using MySQL in struts?

3567


Why do we need mysql?

515


What is mysql procedure?

503


SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

572






How do I find mysql database?

478


How to create a trigger in mysql?

489


What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

521


What is table level locking in mysql?

476


Where’s database data actually stored? Is there a way to see the files which are stored?

500


How many ways to get the current time?

505


Why do we write stored procedures?

472


What are the different types of triggers in mysql?

452


How do I delete a row in mysql?

475


What is the purpose of using ifnull() function?

523