Hi mat,

> -----Original Message-----
> Thanks for reply.
> But the main problem is how to determine the table (MyTable)
> with duplicated values? Is it possible with simple query?

SELECT I.RDB$RELATION_NAME AS TABLENAME,
S.RDB$FIELD_NAME AS FIELDNAME
FROM RDB$INDICES I
LEFT JOIN RDB$INDEX_SEGMENTS S ON (S.RDB$INDEX_NAME = I.RDB$INDEX_NAME)
WHERE (I.RDB$INDEX_NAME = 'RDB$INDEX_2');


See (http://www.fbtalk.net/post.php?action=post&fid=13) for more info.

Rgds

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.net/