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?
- 2 Answers
- 4074 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / satish
select count(*) from sysibm.systables where creator='owner'
select * from sysibm.systables
| Is This Answer Correct ? | 0 Yes | 0 No |
Define db2 and its databases?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What is a view? Why use it?
What is dbrm? What it contains?
How do I create a view in db2?
what is a corelated subquerry?
What is db2 optimizer?
what is SPUFI ?
What information is contained in a SYSCOPY entry?
How many Buffer pools are there in DB2 and what are they?
Are views updateable?
What is meant by concurrency?
COBOL 
