-- Code SQL 1.7
SELECT
     fromColumnName as DelaColonne,
     fromObjectname as DelaTable,
     ToColumnName as AlaColonne,
     toObjectName as DelaTable,  
     typeOfrelationship as TypeDeRelation,
     isActive as EstActive,
     UpdatedAt as DateMiseAJour
FROM Metadata.relationships rl 
INNER JOIN Metadata.relationshipColumns rlc
     ON rl.relationshipid = rlc.relationshipid 