Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 6581 Views
- I also Faced
- E-Mail Answers
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 contained in a SYSCOPY entry?
What are leaf pages?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
List down the types of triggers in the db2 database?
Request to database but database is not available so what is was abend is raised?
Which isolation level provides highest data integrity?
What is sqlcode -922 ?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the purpose of rollback and commit?
What is deadlock?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is dbrm?
COBOL 
