>>>> Thanks in advance.
>>>Yes Creating the view on the fly should be faster
>
>I would test this first- creating a view on the fly and setting a bunch of view properties can take a while...
>
>>>Then, when you want to delete the view:
>>>USE IN Nadya
>>>DROP VIEW Nadya
>
>You should know that doing this repeatedly will results in a continually growing dbc file- Each time you create a new view and delete it, a record is added and deleted.
Erik,
Is there a way to check, if view ViewName already exists in a Database?
Also how can I check, if a table is free or it's part of a Database?
If it's not broken, fix it until it is.
My Blog