Symptom
- Create view that involves 2 tables with ‘union’
- Alter the base table to modify one column that does not involve in the views, select from view got error 208/4413:
1> select * from tempdb..v2
2> go
Msg 208, Level 16, State 1:
Server 'ase157', Line 1:
t1 not found. Specify owner.objectname or use sp_help to check whether the
object exists (sp_help may produce lots of output).
Msg 4413, Level 16, State 1:
Server 'ase157', Line 1:
View resolution could not succeed because the previously mentioned objects, upon
which the view 'a' directly or indirectly relies, do not currently exist. These
objects need to be recreated for the view to be usable.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) ALL Versions
Product
Keywords
view,alter table,view resolution,Msg 4413 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.