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

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

0 Answers  

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

How do I import data from excel to db2?

0 Answers  

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

What is the maximum size of varchar data type in db2?

0 Answers  

What is a db2 package?

0 Answers  

What is the maximum No of rows per page?

0 Answers   IBM,

Explain packages.

0 Answers  

can you use symbolic parameters in JOB?

5 Answers   IBM,

How do I connect my db2 database to ibm?

0 Answers  

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

For more DB2 Interview Questions Click Here
Categories