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 are the benefits of using the db2 database?

658

What does runstats do in db2?

607

What is data manager?

606

How to restart a DB2 program?

1362

Is schema the same as database?

628

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2686

Define buffer pool.

626

What is dclgen (declaration generator)?

601

List out the buffer pools in db2

626

Mention the location where the output received from explain statement is stored.

628

Mention the downsides of page level lock.

707

What are the contents of a dclmgen?

628

What is the physical storage length of the data types date, time, and timestamp?

605

What is access path in db2?

562

What is null indicator in cobol db2?

582