thanks for the replies.

it turns out that the name of my view had been created in error as a table, thats why i couldn't see it in the object explorer window.

therefore used drop table and then managed to re-create the view.