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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gandalf.me@gmail.com - 30 Sep 2005 16:46 GMT

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.

Reply to this Message

Knut Stolze - 30 Sep 2005 16:50 GMT

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

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Brian Tkatch - 30 Sep 2005 16:59 GMT

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.

Reply to this Message