Objects migrated when copying differences

In the structural comparison table, when you copy a difference from the source model to the target database model, additional objects might also be copied to the target model.
Objects can have dependent objects, required objects, and impacted objects:
Dependent object
An object that needs another object to exist. For example, columns, indexes, and primary keys are dependent objects because they all need a table to exist.
Required object
An object that must exist for a dependent object to exist. For example, if Table A is in Schema A, then Schema A is a required object for Table A.
Impacted object
An object that is affected if another object is changed or dropped. For example, if View A references Table A, the view might be impacted by changes that are made to Table A.

When you copy a selected object to the target database model, the required objects and dependent objects for the object are automatically copied.

The following table shows which objects are automatically copied in addition to the selected object.

Table 1. Objects that are copied in addition to the selected objects
Selected object type Objects that are also copied
Schema The schema and its dependent objects, including tables, views, functions, stored procedures, and so on
Table The table and its required objects, including an immediate parent table, the table space, and the buffer pool
View The view, the required schema, and the required referenced objects, such as views, tables, and aliases
Alias The alias, the required schema, and the object on which the alias is defined
Materialized query table The materialized query table and its required objects, including all the tables
Stored procedure The stored procedure
Function The function
Sequence The sequence
Table space The table space and its buffer pool
Buffer pool The buffer pool

Feedback