Cita:
CONSTRAINT_NAME TABLE_NAME FIELD_NAME DESCRIPTION IS_DEFERRABLE IS_DEFERRED ON_UPDATE ON_DELETE MATCH_TYPE REFERENCES_TABLE REFERENCES_FIELD FIELD_POSITION
=============================================================================== ===============================================================================
INTEG_72 ALBARUTA CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_73 ALBARUTA VENDEDOR <null> NO NO RESTRICT RESTRICT FULL VENDEDORES CODIGO 1
INTEG_67 ALBARANES CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_68 ALBARANES VENDEDOR <null> NO NO RESTRICT RESTRICT FULL VENDEDORES CODIGO 1
INTEG_15 LINAMORTIZA SBCUENTA <null> NO NO RESTRICT RESTRICT FULL AMORTIZA SBCUENTA 1
INTEG_97 LINCOMISIONES CODIGOMES <null> NO NO RESTRICT RESTRICT FULL COMISIONES CODIGOMES 1
INTEG_26 CLIENTES VENDEDOR <null> NO NO RESTRICT RESTRICT FULL VENDEDORES CODIGO 1
INTEG_157 LINEASGASTOS CONCEPTO <null> NO NO RESTRICT RESTRICT FULL GASTOS CONCEPTO 1
INTEG_83 LINEASVENTAS CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_84 LINEASVENTAS VENDEDOR <null> NO NO RESTRICT RESTRICT FULL VENDEDORES CODIGO 1
INTEG_94 COMISIONES CODIGO <null> NO NO RESTRICT RESTRICT FULL VENDEDORES CODIGO 1
INTEG_107 TARIFAS GRUPO <null> NO NO RESTRICT RESTRICT FULL GRUPOTAR GRUPO 1
INTEG_53 ABONOS CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_58 DEPOSITOS CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_127 GASOIL MATRICULA <null> NO NO RESTRICT RESTRICT FULL VEHICULOS MATRICULA 1
INTEG_63 HDEPOSITOS CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_111 COMPRAS CODIGO <null> NO NO RESTRICT RESTRICT FULL PROVEEDORES CODIGO 1
INTEG_100 LINREMESASRECIBOS REMESA <null> NO NO RESTRICT RESTRICT FULL REMESASRECIBOS REMESA 1
INTEG_41 PVPSP CODCLI <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_77 FACTURAS CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_78 FACTURAS VENDEDOR <null> NO NO RESTRICT RESTRICT FULL VENDEDORES CODIGO 1
INTEG_34 MANTENIMIENTOS CODCLIENT <null> NO NO RESTRICT RESTRICT FULL CLIENTES CODIGO 1
INTEG_130 GASTOSVEHICULOS MATRICULA <null> NO NO RESTRICT RESTRICT FULL VEHICULOS MATRICULA 1
|
Con el metodo del compañero ECFISA. Lo he copiado a un fichero texto, he agregado un punto y coma al final;
y me devuelve lo que quiero, aunque he descubierto que ese no era el problema lo guardo porque es muy útil, se dirige la salida a un fichero de texto y ahí tienes todas las claves foraneas.
Un Saludo