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
- 5068 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 |
Where is the output of EXPLAIN stored?
How do I delete a table in db2?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
How can we define a table? How can we apply SEARCH ALL on it ?
Discuss about db2 bind?
How to take backup of table in db2?
What is an instance in db2?
Can we declare DB2 HOST variable in COBOL COPY book?
What are the contents of a DCLGEN?
How do you eliminate duplicate values in db2?
On which levels locks can be applied?
What is a LIKE table and how is it created?
COBOL 
