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 / nitesh

Answer Posted / nitesh

SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='<ownername>

eg. SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='NITESH'

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

What is precompiler in db2?

1026

What is the difference between nvl and coalesce?

1065

How can the duplicate values be eliminated from db2 select?

1106

What are the contents of a dclmgen?

1135

What is universal database?

1074

What is the difference between spufi and qmf?

1136

Is ibm db2 free?

1019

What is the difference between cursor stability and repeatable read isolation levels?

1182

What is db2 and what is the use of db2 optimizer?

1071

Which component is responsible for processing sql statements and selecting access paths?

1134

Can we insert update delete in view?

975

How to connect to db2 database from windows command line?

1068

What os does db2 run on?

994

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2334