[SQL] get source table.field name from view's field

Hi, Firstly , sorry about my poor english, I'll do my best to explain what I want. Actually, in most cases, We do query via view, in order to improve the query speed, we'll create index in physical table field that is mapped in view's where statement. So, I got an idea to store view statement in a

[SQL] how to get the source table & field name of a view field

Hi, Could you tell me how to get view field's source table and field name? another word, how could I know the view field come from? Regards, Ho ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]