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

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

1050

Mention some fields that are a part of sqlca.

1014

How do I import data from excel to db2?

1058

How do I delete a column in db2?

1103

What is db2 bind process?

1232

How do you concatenate the firstname and lastname from emp table to give a complete name?

1069

How do I connect my db2 database to ibm?

1037

Is db2 free?

1083

How to test SQL -911 error while developing COB-DB2 program

7536

What is the result of open cursor statement?

1073

How to check last update on table in db2?

1047

How to find primary key of a table in db2?

1054

How to retrieve rows from a db2 table in embedded sql?

1376

What is the difference between plan and package in db2?

1099

Mention the downsides of page level lock.

1156