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
- 6452 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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the use of with ur in db2?
What is multi row fetch in db2?
Give a brief description of db2 isolation levels?
How many databases are there?
What is the difference between dbm cfg and db cfg file in db2 ?
What is difference between alias and synonym in db2?
What is host variable?
What is the physical storage length of timestamp data type?
What is the role of schema in the db2 database?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What are the contents of dclgen?
Is it possible using max on a char column?
How would the varchar column remarks defined?
