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

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 / satish

Answer Posted / satish

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

select * from sysibm.systables

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is database reorganization?

1183

What is table space in db2?

1071

Explain dclgen.

1268

What's The Percentage Free Space ?

1282

What is the syntax for FETCH in DB2 ?

1267

How to view db2 table structure?

1062

What happens in bind step in a db2 program?

1010

What is netezza database?

1080

Define db2.

1168

What is a bind in db2?

1101

How can you quickly find out the # of rows updated after an update statement?

1084

How does a cursor work?

1038

Why do we need reorg in db2?

1042

Is db2 free?

1141

On which levels locks can be applied?

1201