SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='<ownername> eg

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

Answer Posted / nitesh

SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='<ownername>

eg. SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='NITESH'

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you mean by commit and rollback?

592

Before you give the explain statement, what are the prerogatives?

579

Which component is used to execute the sql statements?

619

What is ibm db2 database?

532

What is reorg and runstats in db2?

692

What is the difference between using bind () and rebind () methods of naming class?

788

What is runstats and reorg in db2?

791

My sql statement select avg(salary) from emp yields inaccurate results. Why?

639

How to access db2 tables in mainframe?

611

What is schema in db2?

574

What is the physical storage length of time data type?

673

Which isolation level provides maximum concurrency?

664

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

744

Mention the location where the output received from explain statement is stored.

628

What is explain plan in db2?

588