Dynamic views

Hello friends,
I have a view defined as:-

CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from users, vivek_test where vivek_test.username=users.username;

Now, when I add a new column in vivek_test, I cant see the new column in the view. Currently we have to drop the view and recreate it.
Is there a way that i can see the new column without dropping and recreating the view ?

Thanks for reading this. Thanks for your replies in advance.

With warm regards.
Vivek

vivek(at)staff(dot)ownmail(dot)com

All science is either physics or stamp collecting.
-- Ernest Rutherford