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

can we view the access paths created by dbrm ? how ? thx

6242

What is package in db2 mainframe?

555

What is buffer pool and list some of them?

628

What is a buffer in memory?

596

How do I change the column size in db2?

589

Differentiate between cs and rr isolation levels? Where do you specify them?

580

What is db2 purescale?

545

What is a bind in db2?

590

Explain about rct in db2?

635

What language is db2 written in?

595

How can you classify the locks in db2?

632

What is catalog database in db2?

642

Mention data types used in db2 ?

675

What is explain plan in db2?

588

What is nvl in db2?

624