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?

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

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

Answer / s

do a select on SYSIBM.SYSTABLES

Is This Answer Correct ?    1 Yes 1 No

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

Answer / shankar

Select TBNAME from SYSIBM.SYSTABLES where TBOWNER = ' '

- Try 'NAME' and 'OWNER' if TB prefix does not work.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is pagespace?

1 Answers  


What are bind parameters in db2?

0 Answers  


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  


How would one remove old reorg information from the DB2 catalog?

2 Answers  


What is cursor in dbms?

0 Answers  


select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  


How is deadlock resolved?

0 Answers  


what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,


What is auditing?

2 Answers  


What is the usage of open cursor command?

0 Answers  


what are stage one indexable predicates?

1 Answers  


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


Categories