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

How can you classify the locks in db2?

1096

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2862

Explain about rct in db2?

1116

How to execute stored procedures?

1136

What type of database is db2?

975

Define data page.

1077

what is a corelated subquerry?

1130

What is db2 instance?

1110

How do I delete a column in db2?

1115

What is page size in db2?

987

How do you stop a db2 database in linux?

1021

How to restart a DB2 program?

1912

What are concurrency issues?

1107

How to find the number of rows in a db2 table?

1124

Which is faster delete or truncate?

1137