db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: adding view support to ddlutils
Date Mon, 19 Feb 2007 07:09:53 GMT
On 2/17/07, Ramin Moazeni <rmoazeni@gmail.com> wrote:

> I am looking into adding view support to ddlutils. The ddlutils
> code is using DatabaseMetaData for capturing information
> related to tables/indexes from the source database. The
> problem with using DatabaseMetaData for views is that I cannot
> capture the select statement that was used to create the original
> create view statement. I was wondering if using database system
> tables would be the preferred approach?
> (some databases like mysql provide commands which retrive the
> original create statements. In the case of mysql, the command is
> "show create view")

That is a good idea, however it requires that DdlUtils supports
database-specific definitions/declarations (e.g.
http://issues.apache.org/jira/browse/DDLUTILS-28). But, please create
an issue in JIRA for this.

Tom

Mime
View raw message