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

Answer Posted / s

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How will you return the number of records in table?

886

What is database reorganization?

1068

Where do you specify them?

1185

Explain packages.

1068

How to test SQL -911 error while developing COB-DB2 program

7461

What is reorg?

1086

What is phantom read in db2?

1084

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1058

Can we update view in db2?

954

What is declare cursor?

1054

How can deadlocks be resolved?

899

What is dbrm? When it will be created?

971

How do you stop a db2 database in linux?

968

Explain about dbrm.

997

Mention the downsides of page level lock.

1120