Hello !
It's not that complicated, sqlite already do all work right now but it
doesn't store that information in a structured way "data dictionary".
Cheers !
On 23/03/17 21:17, Simon Slavin wrote:
On 23 Mar 2017, at 10:52pm, Daniel Anderson <woni...@gmail.com> wrote:
Sybase has one.
there is even a way to get objects dependencies
Okay, thanks for the answers. The only way to do this involves quite a
complicated set of dependencies. Consider, for example, having to parse a
TRIGGER to figure out all the TABLEs and VIEWs mentioned inside the stored
procedure, and also all the columns of those tables and views mentioned in the
TRIGGER.
The only way I can see it happening involved a significant modification of
SQLite so that as it parses the schema stored in the database it constructs
this table of dependencies. Nothing simple.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
