do a select on SYSIBM.SYSTABLES

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Give a brief description of db2 isolation levels?

599

Define data page.

628

Explain the function done by data manager?

853

What is host variable?

593

What are the uses of db2 optimizer?

815

What is the difference between drop table and delete table?

550

What are the 2 sqlcodes that are returned?

636

How to check sequence on a table in db2?

598

How do you select a row using indexes in db2?

643

How can record locking be achieved in those DB2 versions which do not support it?

623

What is cascading rollback?

621

Is it possible to create an Instance in DB2 using DB2 Control Center ?

627

How to resolve deadlock issue

17966

How to check table size in db2 sap?

575

What is scrollable cursor in db2?

581