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.
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 |