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
- 4497 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 |
How can you get the number of rows impacted by the last executed query?
What is the maximum size of a char data type in db2?
If I have a view which is a join of two or more tables, can this view be updatable?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How can you do the explain of a dynamic sql statement?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is the use of dclgen in db2?
What is the use of predicate?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is dbrm? When it will be created?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is an alias and how does it differ from a synonym?
COBOL 
