Select TBNAME from SYSIBM.SYSTABLES where TBOWNER = ' '

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 / shankar

Answer Posted / shankar

Select TBNAME from SYSIBM.SYSTABLES where TBOWNER = ' '

- Try 'NAME' and 'OWNER' if TB prefix does not work.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is load utility in db2?

1229

Explain packages.

1171

Explain the benefits you can get from mainframe connect?

1017

What is db2 bind process?

1292

How to restart a DB2 program?

1956

What are host variables in db2?

1122

Explain about open switch business continuity software?

1183

What is ibm db2 database?

1067

What is the syntax for seeing the columns and data types of a table in the db2 database?

1236

Describe major components of db2?

1145

What is the use of db2 optimizer?

1175

How is a typical db2 batch pgm executed?

1227

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1109

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

1089

What do you mean by commit and rollback?

1089