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
- 4897 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 |
What is ibm db2 database?
Can you use max on a char column?
Which isolation level provides maximum concurrency?
What is the syntax for creating a table in the db2 database?
What is dclgen (declaration generator)?
Where is the output of EXPLAIN stored?
How to handle null values in db2
What are column-name qualifiers used?
Explain dclgen.
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
pls tell me abt the normalization five types....
What happens to a cursor after a commit?
COBOL 
