Check Custom Objects
SQL to check if there are any custom objects within the Clarify reserved range
select * from adp_tbl_name_map where ((type_id between 0 and 429) or (type_id between 5000 and 9999)) and type_name like ‘x\_%’ ESCAPE ‘\’
August 9, 2007 by kaimal
Check Custom Objects
SQL to check if there are any custom objects within the Clarify reserved range
select * from adp_tbl_name_map where ((type_id between 0 and 429) or (type_id between 5000 and 9999)) and type_name like ‘x\_%’ ESCAPE ‘\’
Be careful. That SQL not only looks for User Defined tables within the Clarify defined range (0-429, 5000-9999), but it will only return results where the table name starts with “x_”. It is NOT required that custom objects start with “x_”.
So, you may very well have user defined objects in the Clarify-defined range that do not start with “x_”, and those objects would not be returned by that query.