Handling deleted objects and columns

Sometimes objects or columns in your database get dropped. After you import changes to Dataedo, those objects/columns will be marked as deleted.

tip

To learn more see also Handling renamed objects and columns

Deleted objects

After an object in the database (table, stored procedure, etc.) gets dropped, when importing changes, Dataedo lists those in the import wizard.

Deleted objects are marked as deleted but are still visible in the editor. All content is preserved. You may preview such objects and decide to delete them permanently from the repository - all content will be lost.

Deleted objects are marked with red cross icons in the navigation tree.

Deleted objects and their elements are ignored from all exports.

note

Once you delete the object from the repository, its name gets added to the list of ignored objects. If an object with that name is created again, it will be ignored in future imports. Read more about ignoring and removing objects from documentation. :::

Deleted columns, keys, etc.

Similarly to objects (tables, views, etc.), their elements (columns, keys, parameters, etc.) are marked as deleted when missing in import. The idea is the same - copy the description and delete with the Delete key or Remove from repository option in the context menu (right-click).

Removing deleted objects from the repository

If you decide that you don't want a specific object or column in the repository, you can remove it. To remove an object, select the object from the navigation explorer, right-click, and choose the Remove from repository option or press the Remove button in the ribbon.

Objects that get deleted (their names) are added to the ignored objects list.

Removing deleted columns from the repository

To remove a deleted column, you can select it in the Columns tab and choose the Remove from repository option.