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?
- 2 Answers
- 5042 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
select count(*) from sysibm.systables where creator='owner'
select * from sysibm.systables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why db2 is called db2?
What is the use of with ur in db2?
Give the name of some fields form sqlca.
what are bind concepts in db2 cobol?
What is the role of the data page in the db2 database?
What is db2 catalog database?
Explain the function done by data manager?
What is isolation level in db2?
How to compare data between two tables in db2?
What is database manager in db2?
What is the function of logging in the db2 database?
What is difference between alias and synonym in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is host variable in db2 cobol?
How do you find the maximum value in a column in db2?
