Select TBNAME from SYSIBM.SYSTABLES where TBOWNER = ' '

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

Answer Posted / shankar

Select TBNAME from SYSIBM.SYSTABLES where TBOWNER = ' '

- Try 'NAME' and 'OWNER' if TB prefix does not work.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I optimize a query in db2?

1052

Define data page.

1023

How can we retrieve the total number of records in RPG & CLLE?

596

How to find the number of rows in a db2 table?

1086

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1046

Before you give the explain statement, what are the prerogatives?

987

What is the use of predicate?

1001

what is the responsibility of the construction superintendent

2096

How would you find out the total number of rows in a db2 table?

1004

How can you find out the # of rows updated after an update statement?

1076

What are the contents of dclgen?

1069

What is catalog database in db2?

1116

What are bind parameters in db2?

995

How to create db2 table in mainframe?

1113

What does sqlcabc has?

1006