113 reputation
3
bio website
location
age 38
visits member for 1 year, 6 months
seen Jun 23 '13 at 15:31

Oct
24
comment Does MySQL have information_schema.VIEW_COLUMN_USAGE or an equivalent?
Added bummer.. it looks like neither 'TABLE_CONSTRAINTS' nor 'KEY_COLUMN_USAGE' shows any info about primary/foreign keys in the view, so it seems impossible to get that info without prior knowledge of what tables make up the view :-(
Oct
24
comment Does MySQL have information_schema.VIEW_COLUMN_USAGE or an equivalent?
Well, the plus side is that at least i can get column metadata, but it's unfortunate that there's no way to tell from I_S what base tables are involved.. thank you!
Oct
24
awarded  Scholar
Oct
24
accepted Does MySQL have information_schema.VIEW_COLUMN_USAGE or an equivalent?
Oct
23
awarded  Student
Oct
22
asked Does MySQL have information_schema.VIEW_COLUMN_USAGE or an equivalent?
Oct
10
awarded  Supporter