Dear friend, my question is assume that we have created on table,on that table we are creating one view and one synonym know i have drop the table then status of view is invalid but status of synonym is not invalid pls give me the answer

Questions by basukolur014   answers by basukolur014

Showing Answers 1 - 2 of 2 Answers


  • Nov 16th, 2006

hi friend, As per RDBMS rule we cannot have invalid synoym, but we can have a invalid view.

  Was this answer useful?  Yes


  when u do so the view gets error and synonym becomes invalid. If u create a table again with same name but with different cols the synonym will work but view wont.bcz view is the stored select statement but synonym is the replica of the original.view depends on the colms of the table where as syn depends on the name of the table.


Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions