Re: DDL for all database tables

From: Tyler Smith Watu <watuni2000_at_yahoo.co.nz>
Date: 3 Oct 2003 06:36:23 -0700
Message-ID: <2f3438a4.0310030536.4e15118d@posting.google.com>

Dale Edgar <Dale_at_DataBee.com> wrote in message news:<sbaqnvo1h9hu1d1lg8lt6pjm0bgugh7uft_at_4ax.com>...
> On 2 Oct 2003 10:04:20 -0700, watuni2000_at_yahoo.co.nz (Tyler Smith
> Watu) wrote:
>
> >I am in search of a query that can return DDL which can recreate a users tables
>
> Do you want the query or do you really just want the DDL the query
> would produce? If all you really want is the DDL have a look at the
> freeware DBATool. It reads export files and can display and save all
> of the schema (or database) DDL in runnable .sql files.
>
> http://www.DataBee.com/dt_home.htm
>
> - Dale
> -----
> Need test and development databases? You need DataBee.
> Simple and cost effective database subsets. http://www.DataBee.com

Appreciate your responses
Will have a look at databee looks like it may do the trick. I thought there was a data dictionary table to query or may be someone had done a similar thing.

HP unix 11
RDBMS Version 8.1.7.0.0

TYSW Received on Fri Oct 03 2003 - 08:36:23 CDT