I have a mysql view called
To show a list of views that are in you database the
SHOW FULL TABLES IN youdatabasename WHERE TABLE_TYPE LIKE '%VIEW%';
if you want to create a view with that name and you don't care how the view was before you can use the
CREATE OR REPLACE VIEW records_latest ....
this will delete the previous view if it exists and then will create the view again