Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Views » View dependencies

 

Dependencies and schema-altering changes

An attempt to alter the schema defined for a table or view requires that the database server consider if there are dependent views impacted by the change. Examples of schema-altering operations include:

  • Dropping a table, view, materialized view, or column

  • Renaming a table, view, materialized view, or column

  • Adding, dropping, or altering columns

  • Altering a column's data type, size, or nullability

  • Disabling views or table view dependencies

 Events that take place during schema-altering operations
 Regular views: dependencies and schema alterations
 Materialized views: dependencies and schema alterations
 See also