Object name model validation

[PMax]

Hi all!
Please help me with this question:
how to check my business model for duplicate names of model elements ?
Thanks for replies,
Max

[KP]

You will probably want to use the Manage Searches dialog to create a custom SQL query, something like this:

Code: [Select]

SELECT FirstObject.Name, FirstObject.Object_ID, FirstObject.Object_Type
FROM t_object AS FirstObject, t_object AS SecondObject
WHERE FirstObject.Name = SecondObject.Name
AND FirstObject.Object_Type = SecondObject.Object_Type
AND FirstObject.Object_ID <> SecondObject.Object_ID
AND FirstObject.Package_ID = SecondObject.Package_ID
ORDER BY FirstObject.Name

[PMax]

Ok, thank KP.  The statement i can run on database level. Can I do this from EA IDE(for my designer)?

[KP]

Edit > Find in Model > Manage Searches > New Search > SQL Editor > OK. Once you've saved the search, you can re-run it with Ctrl+F...

[PMax]

Wow ! super product.
KP, thanks a lot !
Max