On Dec 8, 2010, at 2:44 PM, Richard Hipp wrote:
> On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille <petite.abei...@gmail.com
> >wrote:
>
>> Hello,
>>
>> The pragma foreign_key_list appears to be deprecated in 3.7.4:
>>
>> http://www.sqlite.org/pragma.html#pragma_foreign_key_list
>>
>> Any reason for such deprecation?
>>
>
> Now that foreign key constraints are enforced natively, why would
> you want
> to have a list of them? Why should the foreign_key_list pragma
> continue to
> consume code space and developer maintenance time?
>
Why would a developer NOT want to be able to query any part of the
data dictionary
to see any aspect of the schema? In addition to the info in
sqlite_master, it would
be nice to be able to access column information as a query rather then
a pragma.
For example, on Oracle you can get a list of foreign keys, like:
select
owner
,constraint_name,constraint_type,table_name,r_owner,r_constraint_name 2
from all_constraints where constraint_type in ('P','U')
Sybase provides the "sp_fkeys" system stored proc for the same purpose.
If the point is that SQLite is meant to be be small and embedable, maybe
the extra data dictionary querying capability can be provided by a
separate,
laodable extension.
-Chris
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
