I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this ?
The query SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR = ‘owner id’ This displays the table names with that If you want only the number of tables give the following query. SELECT COUNT(*) FROM SYSIBM.SYSTABLES WHERE CREATOR = ‘owner id’ Make sure that you are in correct subsystem.