Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Unanswered: get ddl scripts of existing tables

    Hello I am new to db2, what is the easiest way (if there is a way) to get the sql scripts (create table) of tables in an existing db2 database. This database runs on a Db2 v 7.2 Server. I access it via client connection (I can access the server too). What tool can I use and how can I get the SQL scripts?

    Cheers Baumi

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: get ddl scripts of existing tables

    db2look -d <dbname> -e

    Have a look at
    Command reference for more options

    Cheers

    Sathyaram

    QUOTE]Originally posted by baumi78
    Hello I am new to db2, what is the easiest way (if there is a way) to get the sql scripts (create table) of tables in an existing db2 database. This database runs on a Db2 v 7.2 Server. I access it via client connection (I can access the server too). What tool can I use and how can I get the SQL scripts?

    Cheers Baumi
    [/QUOTE]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •