Hi ,

I want to create a class in lib folder , from that class want to create mysql view .
such as in mysql

CREATE VIEW rocket_current_activities AS
    SELECT rocket_activities.status  AS status from rocket_activities....

This can be do in mysql but how to do from rails.
I dont want in migration file.
Please help!!!

The question is why do you need to create view in Rails? You should not need to be manipulating with database schema at all but rather use Rails' object to do that for you. Weird...