Exclamation point next to view name

[former_SQLA_member1694903]

In Sybase Central (ver 16), I see a tiny exclamation point in the icon next o the name of one of my views. What is that telling me?

[Former Member]

An Icon with a white 'X' on red background indicates a view has been disabled. An Icon with a black '!' on yellow background indicates the view is invalid; quite probably due to it referencing an object that no longer exists.

You can reproduce this easily this if you create a simple view on a table and then drop that table. View dependencies have been tracked since 11.0.0 and this is the visible manifestation of that feature.

HTH

[VolkerBarth]

A slight correction: View dependencies were already part of v10:)

http://dcx.sap.com/index.html#1001/en/dbwnen10/wn-newjasper-s-3687026.html