Tablas, campos y claves foráneas

Tablas, campos y claves foraneas

Tablas, campos y claves foraneas : Multi-millones de consejos para hacer su vida mas facil.

Un complicado consulta SQL que yo tenia que trabajar para decirme informacion acerca de la base de datos actual.

Esta consulta le dira
TableName, FieldName, FieldType, FieldSubType, ForeignTableName, ForeignFieldName

select distinct
& nbsp & nbsp Rel.rdb$relation_name TableName,
& nbsp & nbsp Rel.rdb$nombre_campo FieldName,
& nbsp & nbsp Fld.rdb$field_type FieldType,
& nbsp & nbsp Fld.rdb$field_sub_type FieldSubType,
& nbsp & nbsp FCon.rdb$Relation_Name ForeignTableName,
& nbsp & nbsp FIseg.rdb$Nombre_campo ForeignFieldName

& nbsp & nbsp rdb$relation_fields Rel
& nbsp & nbsp left join
& nbsp & nbsp & nbsp & nbsp rdb$relation_constraints Con
& nbsp & nbsp
& nbsp & nbsp & nbsp & nbsp (Const. rdb$relation_name = Rel.rdb$relation_name y
& nbsp & nbsp & nbsp & nbsp & nbsp Const. rdb$constraint_type como 'EXTRANJEROS%')
& nbsp & nbsp left join
& nbsp & nbsp & nbsp & nbsp rdb$indices IDX
& nbsp & nbsp
& nbsp & nbsp & nbsp & nbsp IDX.rdb$index_name = Const. rdb$index_name
& nbsp & nbsp left join
& nbsp & nbsp & nbsp & nbsp rdb$index_segments ISeg
& nbsp & nbsp
& nbsp & nbsp & nbsp & nbsp (ISeg.rdb$index_name = Idx.rdb$index_name y
& nbsp & nbsp & nbsp & nbsp & nbsp ISeg.rdb$Nombre_campo = Rel.rdb$nombre_campo)
& nbsp & nbsp left join
& nbsp & nbsp & nbsp & nbsp rdb$Relation_Constraints FCon
& nbsp & nbsp
& nbsp & nbsp & nbsp & nbsp FCon.rdb$index_name = Idx.rdb$Foreign_Key
& nbsp & nbsp left join
& nbsp & nbsp & nbsp & nbsp rdb$index_segments FIseg
& nbsp & nbsp
& nbsp & nbsp & nbsp & nbsp (FISeg.rdb$index_name = Idx.rdb$Foreign_key y
& nbsp & nbsp & nbsp & nbsp & nbsp FISeg.rdb$Field_Position = ISeg.rdb$Field_Position),
& nbsp & nbsp rdb$campos Fld,
& nbsp & nbsp rdb$Relation_Fields RFld
donde
& nbsp & nbsp Rel.rdb$relation_name no como 'RDB$%' y
& nbsp & nbsp Fld.rdb$nombre_campo = Rel.rdb$field_source y
& nbsp & nbsp RFld.rdb$Relation_Name = Rel.rdb$Relation_name y
& nbsp & nbsp RFld.rdb$nombre_campo = Rel.rdb$nombre_campo
fin
& nbsp & nbsp Rel.rdb$relation_name,
& nbsp & nbsp RFld.rdb$Field_ID