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 a dbrm in db2?

1031

How is deadlock resolved?

1152

What is a collection in db2?

1042

What is the difference between db2 and oracle?

1135

Explain about open switch business continuity software?

1140

What are catalog tables in db2?

1053

What is concurrency?

1241

What is the difference between plan and package in db2?

1124

What is multi row fetch in db2?

1055

How to restart a DB2 program?

1911

What is database alias db2?

1132

What is a Foreign Key?

1104

What are the benefits of using the db2 database?

1236

How to run db2 command in windows?

1200

What is db2 connect?

1081