Change Type for MANY attributes?

[ChuckZ]

Is there a way to "batch" change the type of many attributes? My problem is that I currently have attributes typed as primitives and desire to all of those primitives to a specifically named type def.

Is there a way to do a find AND REPLACE for types?

[g.makulik]

Maybe it's possible to use an appropriate UPDATE statement directly on the database to achieve this. But there are more experienced experts than me lurking on this user forum to give you a possible example how such UPDATE statement could look like.

Look forward, may be specify your conditions more exactly to match the attributes you want to change.

Best regards,
Günther

[Geert Bellekens]

Chuck,

The cleanest solution would be to write a little script/add-in that replaces the type of the attributes.
Now because that is still a bit of work, I would probably opt for the dirtier SQL update approach.

You will need to set the Classifier column on the t_attribute table to the ObjectID of the datatype.

I would use a query as following:

Code: [Select]

select *
--update a set a.Classifier = 2146289599
from t_attribute a
where a.Type like 'DateType'
and (a.Classifier = 0 OR a.Classifier is null)
Geert

[ChuckZ]

Thanks Guys!

SQL is better than making errors by hand-jamming