nisargkothari

 Profile Answers by nisargkothari 

• Sep 16th, 2010

 

The view will not work and for refreshing the view you have to query

sp_refreshview 'viewName'

MANIMALARIT

 Profile Answers by MANIMALARIT 

• Mar 26th, 2011

 

once we drop the whole table s deleted
The table structure is removed from the database. Once a table is dropped we cannot get it back.we cannot view that table .

 

infa_dev

 Profile Answers by infa_dev 

• Sep 4th, 2011

 

Oracle will throw following error

ORA-04063: view "viewname" has errors

sivaraj6389

 Profile Answers by sivaraj6389 

• Sep 7th, 2011

 

Msg 208, Level 16, State 1, Line 1
Invalid object name 'Table Name'.
Msg 4413, Level 16, State 1, Line 1
Could not use view or function 'view Name' because of binding errors.