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
- 6549 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define predicate?
What does db2 plan contain?
What is view db2?
How to test SQL -911 error while developing COB-DB2 program
What is bind plan?
Define buffer pool.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the function of logging in the db2 database?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I delete a table in db2?
What is a dbrm in db2?
What is data manager?
Why select is not preferred in embedded sql programs?
What are packages in db2?
How to execute stored procedures?
