469,271 Members | 1,014 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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

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
2 1908
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Brett Selleck | last post: by
reply views Thread by microdevsolutions | last post: by
1 post views Thread by TY | last post: by
6 posts views Thread by Kevin Chambers | last post: by
1 post views Thread by news.magnet.ch | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.