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 difference between isnull and coalesce?

1056

Define buffer pool.

1060

What are the 2 sqlcodes that are returned?

1190

What is deadlock in db2?

1070

What is bind plan?

1049

List out the data types available.

1153

What are iseries servers?

1075

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104

Explain the contents that are a part of dclgen.

1093

What is the cobol picture clause of the db2 data types date, time, timestamp?

1068

How to find the maximum value in a column in the db2 database?

1084

How many databases can be created inside an instance in db2 ?

1035

Is ibm db2 open source?

1076

What is cobol db2?

1003

What are the contents of a dclmgen?

1131