How to find number of custom tables?

[Piotr Sadowski1]

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?

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

Thank you for your help 🙂

[Piotr Sadowski1]

Thank you @pooja, @Jaspal Singh, @Sulabh Garg and @Sumanth Dosapati for your quick response.

In Custom Table Inventory [ua_custom_table_inventory] and in "Custom Table Subscription Overview" dashboard it show me 24, but when I run query against Tables [sys_db_object] which start with u_ or x_ it shows me 61.
Do you any idea why so?

[Marc Mouries]

The document about Custom tables does NOT say that there is a limit of 50 custom tables. It says ServiceNow limits the number of columns (Custom Table Fields) in a custom table to 50. The number of custom tables you can create depends on the type of product you use. Each product ITSM, HR, CSM comes with a set maximum number of tables. App Engine on the other hand does not have any limit on the number of tables as the goal of App Engine is to create custom applications. So using App Engine, you can have 200 custom tables and each table can not have more than 50 columns.