Identify custom tables in a scoped app?

[An Hong]

Is there a way to identify custom tables in a scoped app? Custom tables in global would have a u_ prefix in their names, but custom tables in a scoped app can have arbitrary names. Can I rely on some method or attribute to identify a custom table besides name?

Thanks

[Cody Smith _ Cl]

Hello An,

The best way to see which tables are scoped tables are to go to 'sys_db_object' table. This is your table for all tables. And then sort by "Package" this will show you which scope the table is in. You could also sort by "Created By" and anything not by System is a custom table.

If my answer was helpful, or solved your issue, please mark it as Helpful / Correct.

Thank you,

Cody Smith

[An Hong]

@Cody Smitth.   Thanks, filtering out "Created By" system certainly eliminates most of the OOB tables (in my case, those created by the Security Incident Response app).  There are a few OOB tables for this app created by Admin, but your answer surely helps.

An Hong

[Cody Smith _ Cl]

I am glad this helped you. If my answer solved your issue, would you please mark it correct?

Thank you (: