#19 DDL copy and Export/Import of View

[yae]

I have two requests about View:

1.
When we copy a View as DDL, a SQL statement to
create Table is copied.
Could you make SQL statement to create View?

2.
It would be useful if we can export Views

[Nobody/Anonymous]

Logged In: NO

1. As you know a view is the result of a select statement.
The JDBC standard knows no way to retrieve the statement a
particular view is based on from the database connection.
Currently I am writing some extension mechanism to provide
database specific information beyond the JDBC standard. I
will consider providing a new view element that knows about
it's creation statement.

2. I think you mean a simple 'create view' statement by
'export a view'. This should be possible.

Uwe