Обсуждение: view vs. tables used to define that view

Поиск
Список
Период
Сортировка

view vs. tables used to define that view

От
Emi Lu
Дата:
May I know is it possible to query dictionary table(s) in order to 
return relationship between a view and table(s) please?

For example, create view v1 as (select ... from T1 left join T2 ... )

Result:
view Name | Table Name
====================
v1        | T1
v1        | T2

Thanks a lot!
Lu Ying