Can I use a view based on missing table?

[estersita]

Hi,

I wonder if I can use a view which was based on the table which was deleted?

Thank you in advance

Estersita

 

[Turkbear]

Hi,Nope..The view is just a prebuilt query that uses the table..No Table, No View results.

 

[bookouri]

Do you mean "use" or do you mean "create"??

If i remember right, you can "create" a view that uses a missing table, but you have to use a switch of some kind to force it to create in spite of errors..

but, like Turkbear says, if the table is not there, there's no data for the view to retrieve..