How to find number of custom tables?

Piotr Sadowski1
Tera Contributor

Hi,

could you help me please how can I find number of custom tables which were created?
I want to check if we do not reach the limit of 50 custom tables. I read this document custom-table-guide.pdf

Does such query on Tables [sys_db_object] should be good qualification to display all custom tables?

find_real_file.png

Or maybe there is a better way to find number of custom tables which were created?

Thank you for your help 🙂

11 REPLIES 11

Pooja49
Tera Expert

Custom tables names are start with x_ or u_

Try to search in Name column 

 

If this solution helps please mark it as helpful.

 

Thanks

Pooja J

 

Jaspal Singh
Mega Patron
Mega Patron

Simply report on 

Custom Table inventory

find_real_file.png

@Piotr Sadowski Good to know you found related comment helpful. If you go what was expected close the thread by marking suitable answer correct so as to move it from unanswered list.