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
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 |
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 |
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What are the various locks available?
what is the responsibility of the construction superintendent
What are types of indexes?
Explain in detail about buffer manager and its functionalities?
How can record locking be achieved in those DB2 versions which do not support it?
is it possible to get -811 error when you use cursors. why?
When will you chose to run RUNSTATS?
What is dbrm? What it contains?
What are column-name qualifiers used?
can any body explain about plan and pakage in detail....