Sybase has one. there is even a way to get objects dependencies, I have been working on a project for the last 5 years using sybase (ASE). very huge project and whenever we must alter the schema we have tools to tell us which store proc, triggers, views will be impacted. it allow us to reach the different stake holders impacted so they can assess how the change will impact them.
also, because the way ASE works, they must provide some way to find dependencies, because all objects which depends on table must be recreated when that table is changed (according to doc) if not the view/triggers/sproc might not do what you expect or fail. ex: create proc ert as select * from user_table where country = 'canada' if a column is added at the end to user_table and the proc ert is not recreated, it will not see the new column. if a column is drop the proc will fail to execute if a column is added in the middle then undefined behavior. so with that kind of behavior it is good that sybase provide a way to find the dependencies. 2017-03-23 7:56 GMT-04:00 Simon Slavin <slav...@bigfraud.org>: > > On 23 Mar 2017, at 11:25am, Domingo Alvarez Duarte <mingo...@gmail.com> > wrote: > > > This problem and other related with the lack of a "data dictionary" in > sqlite, > > Not sure what you expect here. Can you point me at a "data dictionary" > for some other implementation of SQL ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Daniel *L'action accède à la perfection quand, bien que vivant, vous êtes déjà mort* *Bunan* _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
