do a select on SYSIBM.SYSTABLES

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

3 Answers
6573 Views
I also Faced
E-Mail Answers

Answer Posted / s

do a select on SYSIBM.SYSTABLES

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is commit in db2?

1055

Mention data types used in db2 ?

1159

How does cobol compile db2 program?

1060

What is a system catalog table in db2?

1186

what is the sqlcode -501

13152

What is copy pending and check pending in db2?

1004

Is db2 a mainframe?

1043

What is dbrm in db2 database?

1117

What is the information associated with sysibm.syslinks table?

1125

What are concurrency issues?

1097

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1439

What language is db2 written in?

1049

What is data manager?

1049

What is bind and rebind in db2?

1139

What is the maximum number of columns in a db2 table?

1285