I need to view the number of tables existing under one particular Owner. Is it

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

2 Answers
5143 Views
I also Faced
E-Mail Answers

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

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers

What are foreign keys?

1 Answers

db2 restart logic ?

1 Answers DELL, HTC, UHG,

How do you check for a null value in a db2 column?

2 Answers

What is the picture clause of the null indicator variable?

6 Answers

what is datacom db?

2 Answers CSC,

Mention data types used in db2 ?

0 Answers

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers HCL,

What is the function of the Data Manager?

2 Answers

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers UST,

What is package in cobol db2?

0 Answers

What is the difference between Primary key and unique index?

6 Answers

For more DB2 Interview Questions Click Here