I need to view the number of tables existing under one particular Owner. Is it

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?

Question Posted / guest

Answers were Sorted based on User's Feedback

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl..

SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;

Is This Answer Correct ?

4 Yes

0 No

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl..

Answer / satish

select count(*) from sysibm.systables where creator='owner'

select * from sysibm.systables

Is This Answer Correct ?

0 Yes

0 No