Does the view continue to exist if the table is dropped from the database ?

 Posted by Akiii on 6/2/2012 | Category: Sql Server Interview questions | Views: 3232 | Points: 40
Answer:

If you drop the underlying tables by which the view is created then you will get an error while querying the view.

For example :-

Could not use view or function 'testdb.dbo.cutomerid_1_view_details' because of binding errors.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response