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

3 Answers
6538 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

On which levels locks can be applied?

1118

What is bind in db2?

1030

what is the role of the cursor in db2?

1058

What is the maximum size of a char data type in db2?

1000

How do I import a csv file into db2?

978

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2055

What is the default page size of buffer pools?

1118

What are union and union all?

974

What is check constraint in db2?

1070

What is the use of with ur in db2?

1047

What is the difference between cursor stability and repeatable read isolation levels?

1163

How can we read records for specific member in CL? AND rpg?

688

What are the various data types available in db2?

1080

What r the comman abends in db2, jcl and cobol???????

2250

How is the value function used?

1145