select c.table_name,
c.constraint_name,
fc.table_name,
fc.constraint_name,
cc.column_name,
fcc.column_name
from user_cons_columns fcc,
user_cons_columns cc,
user_constraints c,
user_constraints fc
where fc.constraint_name = c.r_constraint_name
and fc.constraint_name = fcc.constraint_name
and c.constraint_name = cc.constraint_name
and c.constraint_type = 'R'
and fc.table_name in ('T_PRODUCT')
c.constraint_name,
fc.table_name,
fc.constraint_name,
cc.column_name,
fcc.column_name
from user_cons_columns fcc,
user_cons_columns cc,
user_constraints c,
user_constraints fc
where fc.constraint_name = c.r_constraint_name
and fc.constraint_name = fcc.constraint_name
and c.constraint_name = cc.constraint_name
and c.constraint_type = 'R'
and fc.table_name in ('T_PRODUCT')
本文介绍了一个SQL查询案例,用于检索与指定表'T_PRODUCT'相关的表结构信息,包括约束名称、列名称等,有助于理解数据库中表之间的关联。
5613

被折叠的 条评论
为什么被折叠?



