Toad World® Forums

Deleting an attribute across a logical data model ?

Hi I have inherited a database that has evolved over time, and the developers have added some filed that are of little if no use. Is there a way of deleting/removing an attribute across the entire model ? I also have a need to change the datatype across the board.

Terry

Hi Terry,

to delete attribute from a model open the Object Viewer Window | Object Viewer...) and try to find the attribute by name:

delete-attribute.png

Re changing data type: there are various ways how to achieve the desired result. In case your model is larger and criteria for the change cannot be to set easily, I recommend export/import to Excel.

Open your model and select File | Export | Export to Excel...

change-datatype1.png

The model metadata will be exported to excel. Change the data types on sheet Attributes, save the file and close Excel.

Then import the Excel file back to your model.

change-datatype3.png

Regards,

Vaclav

Thanks, Ill give this a try