Subject SQL Statement Depandance Mapping
Author Daniel_Work@nemmco.com.au
SQL Statement Dependency Mapping

I had an idea for a tool / API extension for obtaining the schema
dependencies of a DML statement.

My theory goes like this, Interbase's SQL query engine would already be
able to determine tables, columns, etc that a statement requires for
execution.

If these requirements could some how be extracted and dumped into a file
together with the requirements of other SQL statements an overall schema
dependency map for an application could be built.

For example I could see a Delphi expert scanning through the forms in a
project extracting the SQL from queries for dependency mapping.

Does this sound like a feasible/usefully idea?

Would it be a new tool or an extra set of API calls?




PS I haven't been following the list too closely so if this isn't a new
idea please be kind ;-)