Re: Get the CREATE TABLE statement from an existing database

The information is there, but you have to put it together yourself. Try looking at the following views for starters:

   USER_TABLES, USER_TAB_COLUMNS, USER_CONSTRATAINTS, USER_CONS_COLUMNS, USER_INDEXES, USER_IND_COLUMNS
There is no one singular table or view which will give you all the information that you seek.

HTH,
Brian

JJ wrote:
>
> Hi,
>
> I want to get the hands on the CREATE TABLE statement from an existing
> database table through JDBC. Is this possible?
>
> // Jocke
Received on Wed Jun 20 2001 - 08:06:26 CDT