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

How would the varchar column remarks defined?

858

Mention some fields that are a part of sqlca.

795

How do I import data from excel to db2?

843

What is db2 bind?

826

What is the reason behind not using select * in embedded sql programs?

862

Explain db2.

826

How many types of page locks can be held in db2?

829

What is meant by union and union all?

787

What is a db2 cursor?

813

What does sqlcabc has?

804

How to rename a table in DB2 ?

832

What does reorg do in db2?

791

What is the role of schema in the db2 database?

924

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

When do you specify the isolation level?

806