Yeah, thanks! But I've already tried this approach, and it's not quite i need. Because as i understand foreign keys are built on indexes, so i get *index* and corresponding foreign key definition. Well then i have to find out what filed this index "belongs to" (assuming 1 field - 1 index) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend