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.

Popularity: unranked [?]

Related interview questions

• 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?
• 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?
• In which column of which DB2 catalog would you find the length of rows for all tables?
• Once you create a view, where would information about the view be stored?
• What more info you should give in the DD statement while defining the next generation of a GDG? – GS