On 2/17/07, Ramin Moazeni <[EMAIL PROTECTED]> 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
