Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / guest

Answers were Sorted based on User's Feedback



I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl..

Answer / s

SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;

Is This Answer Correct ?    4 Yes 0 No

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl..

Answer / satish

select count(*) from sysibm.systables where creator='owner'

select * from sysibm.systables

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the use of with ur in db2?

0 Answers  

Explain dclgen.

0 Answers  

How to resolve deadlock issue

5 Answers   IBM,

What is the difference between CS and RR isolation levels?

1 Answers  

How to find the number of rows in a db2 table?

0 Answers  

Explain the contents that are a part of dclgen.

0 Answers  

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

Can there be more than one cursor open for any program?

0 Answers  

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

How Plan is created while executing the query using SPUFI?

3 Answers  

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

For more DB2 Interview Questions Click Here
Categories