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

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

Answer Posted / s

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is database manager in db2?

1066

What is isolation level in db2?

1069

What is ibm db2 connect?

1057

Define predicate?

1204

What is reorg?

1244

How to connect to db2 database from windows command line?

1139

What is the role of data manager in the db2 database?

1158

What are catalog tables in db2?

1106

What are union and union all?

1039

Can there be more than one cursor open for any program?

1225

What is buffer pool and list some of them?

1096

What are types of indexes?

1189

How to run db2 command in windows?

1246

What is the difference between db2 and oracle?

1178

What is database reorganization?

1185