Hi, I found the document from MySQL website, MySQL seem doesn''t support view. Is it true? Also, MS Access also doesn''t support view. We can also use use ''create view myview.....'' to create a view in access but how to drop the view? i tried ''Drop view myview'', it doesn''t work. How to do it? Pls help. Thanks