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.

Nov 12 '05 #1

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

Nov 12 '05 #2

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.

Nov 12 '05 #3