SqLite buscando FK

[bjverde]

Como nos banco MySQL e Sql Server buscar as informações de campos

• PK
• FK

[bjverde]

PRAGMA table_info(mytable);
PRAGMA foreign_key_list(mytable);
PRAGMA index_list(mytable);

https://stackoverflow.com/questions/10472103/sqlite-query-to-find-primary-keys