Hello,
I''m wondering if there is any plan to leverage SQL92 INFORMATION_SCHEMA
in ActiveRecord?
In a nutshell, INFORMATION_SCHEMA provides the meta information
necessary to automatically discover all the associations between
objects (primary and foreign keys, has_many, has_one and belongs_to,
etc).
Most relational databases do support this SQL92 standard one way or
another*:
http://dev.mysql.com/doc/mysql/en/information-schema-tables.html
http://www.postgresql.org/docs/current/static/information-schema.html
http://www.sqlite.org/cvstrac/wiki?p=InformationSchema
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
tsqlref/ts_ia-iz_4pbn.asp
Thoughts?
Cheers,
--
PA, Onnay Equitursay
http://alt.textdrive.com/
* Oracle is in a world by itself... but it would be straightforward
enough to provide a set of INFORMATION_SCHEMA compatible views derived
from Oracle''s own data dictionary and/or DBMS_METADATA.
http://www.oreillynet.com/pub/a/network/2002/10/28/data_dictionary.html
