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 information is held in SYSIBM.SYSCOPY?
How does DB2 use multiple table indexes?
What is ibm db2 connect?
What is the role of data manager in the db2 database?
What information can you find in SYSIBM.SYSLINKS table?
What is a Cartesian product?
What is db2 plan table?
What are the three types of page locks that can be held?
How to define the data items to receive the fetch items for the SQL?
Why do we use cursor?
wt is view ? wht r the restrictions for view ?
What is QUIESCE?