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?

Answers were Sorted based on User's Feedback



I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl..

Answer / nitesh

SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='<ownername>

eg. SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='NITESH'

Is This Answer Correct ?    2 Yes 1 No

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl..

Answer / s

do a select on SYSIBM.SYSTABLES

Is This Answer Correct ?    1 Yes 1 No

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl..

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

Post New Answer

More DB2 Interview Questions

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  


What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  


What are the various locks available?

5 Answers   CTS,


what is the responsibility of the construction superintendent

0 Answers   Almco,


What are types of indexes?

0 Answers  


Explain in detail about buffer manager and its functionalities?

0 Answers  


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

0 Answers  


is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,


When will you chose to run RUNSTATS?

1 Answers  


What is dbrm? What it contains?

0 Answers  


What are column-name qualifiers used?

1 Answers  


can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,


Categories