Re: Extract SQL statement used to create table

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

I am rereading your original post ... if the file was created using
Create table as (select....) then this information is not going to be
stored with the table. 

As Luis said, all you can get is the SQL table definition. 

Paul 

On 2017-06-27 12:20, Dan wrote:

> I know I've seen DSPFD show the SQL statement used to create a table or
> view.  I've got a table that I'm 99% certain was created with SQL, but
> DSPFD shows no SQL statement.  DSPOBJD shows no source file/library/member
> data for this table.
>
> This table was very likely created with a CREATE TABLE x as (select ...)
> WITH DATA.  Is there a system view that would have this information?
>
> Google is either not my friend or I'm searching with the wrong terms.
>
> - Dan