SELECT count(*) from SYSIBM.SYSTABLES WHERE CREATOR = 'OWNER' ;

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

2 Answers
5005 Views
I also Faced
E-Mail Answers

Answer Posted / s

SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List some fields from sqlca?

1049

What is the purpose of using commit?

1086

What are the rules for db2 programming?

1078

Where do you specify them?

1260

How to take backup of table in db2?

1065

What is alias in db2?

1038

What is a Foreign Key?

1085

Explain the contents that are a part of dclgen.

1085

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8258

What do you mean by commit and rollback?

1028

What is the role of union all and union

1115

How do I delete a column in db2?

1102

What is cursor stability in db2?

1347

What is the use of value function?

1140

Explain how can you do the explain of a dynamic sql statement?

1111