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 the max length of sqlca?

981

Explain package in db2 and its advantages?

869

Define db2.

873

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1809

Explain about open switch business continuity software?

853

What is the use of db2 optimizer?

840

What is view db2?

859

How to create backup table in db2?

863

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

878

What is dbrm? When it will be created?

785

What is multi row fetch in db2?

792

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1997

What is db2 connect?

818

What is dbrm? What it contains?

920

How to check last update on table in db2?

831