Exporting just schema/metadata (w/o data) in DB2

[gandalf.me]

I was just wondering if we can export just the schema/metadata in DB2
(i.e. just the table and column information, without the data). Is
there an easy way to do this in DB2?

Thanks in advance.

[Knut Stolze]

ga********@gmail.com wrote:

I was just wondering if we can export just the schema/metadata in DB2
(i.e. just the table and column information, without the data). Is
there an easy way to do this in DB2?

Have a look at the "db2look" tool.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Brian Tkatch]

If you are looking for a script to run, the db2look tool is best. If
you want to query it, the system catalog tables have it. Look at SQL
Reference Volume 1 Appendix D "Catalog Views". Of specific interest
would be SYSCAT.TABLES and SYSCAT.COLUMNS.

B.