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
- 6407 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by dclgen?
What is dclgen in db2?
What is ibm db2 connect?
Explain in brief how does db2 determine what lock-size to use?
How do you select a row using indexes in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How do I add a column to an existing table in db2?
What is db2 stogroup?
How to compare data between two tables in db2?
What is the maximum size of varchar data type in db2?
What is lock escalation in db2?
What is nvl in db2?
What is sqlca’s maximum length?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is cursor with hold option in db2?
