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
5063 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

Can you use max on a char column?

1101

What is the physical storage length of time data type?

1138

What is dbrm library?

1077

What is db2 catalog database?

1050

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2252

What is buffer pool and list some of them?

1046

What is with ur in db2?

1331

List down the types of triggers in the db2 database?

1036

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1088

What is ibm db2 client?

948

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

1187

What are catalog tables in db2?

1056

What is bufferpool in db2?

1059

What is the maximum size of varchar data type in db2?

1139

Is db2 free?

1100