A computer implemented method for foreign key, FK, identification in a databases management system, the method comprising: creating a superset of primary key-foreign key, PK-FK, pairs based on a selected schema of a metadata and FK data, wherein the superset of PK-FK pairs is obtained by pairing each of known PKs to each of probable FKs, wherein FK associated with the superset of PK-FK pairs is based on a predefined standard rule, and wherein PK associated with the superset of PK-FK pairs is based on a user query, wherein the selected schema comprises one of a structure of a database server described in a formal language supported by DBMS, organization of data to create a blueprint of constructional details of the database server and data that can be received as an input into the database server; computing a threshold value for each of a primary key-foreign key, PK-FK, pair of a superset of PK-FK pairs based at least on a data type and a length of the columns of the superset of PK-FK pairs, wherein the threshold value is further based on a standard principle of FK column and on an analysis of a data type and a length of columns of the superset of PK-FK pairs; eliminating columns which cannot be part of FK from all the tables in the selected schema based on the standard rules; generating a sub-set of PK-FK pairs by comparing the computed threshold value with a predefined threshold value, wherein the subset of PK-FK pairs is a subset of the superset of PK-FK pairs, and wherein the predefined threshold value is indicative of an acceptance criterion of the PK-FK pairs from the super-set of PK-FK pairs to form the sub-set of PK-FK pairs; computing a cumulative probability distribution, CPD, for each of PK and FK values in the sub-set of PK-FK pairs based on PK and FK columns; determining a conformance score for each of the PK-FK pairs of the subset of PK-FK pairs, wherein the conformance score is maximum difference between computed corresponding Cumulative Probability Distribution, CPD, values of PK and CPD of FK for each PK-FK pair of the sub-set of PK-FK pairs and wherein the conformance score is computed with respect to a range and a variation for the sub-set of PK-FK pairs; comparing the conformance score of the each PK-FK pair of the sub-set of PK-FK pairs with a predetermined acceptability index, wherein the predetermined acceptability index is indicative of an acceptance of at least one positive FK from the set of PK-FK pairs, wherein the FK identification involve further analysis of rows of data and hence removal of false-positives FK results in use of less processing power, saving in time and effort; and storing the identified FK in a memory and presented in a report format using an interface. creating a superset of primary key-foreign key, PK-FK, pairs based on a selected schema of a metadata and FK data, wherein the superset of PK-FK pairs is obtained by pairing each of known PKs to each of probable FKs, wherein FK associated with the superset of PK-FK pairs is based on a predefined standard rule, and wherein PK associated with the superset of PK-FK pairs is based on a user query, wherein the selected schema comprises one of a structure of a database server described in a formal language supported by DBMS, organization of data to create a blueprint of constructional details of the database server and data that can be received as an input into the database server; computing a threshold value for each of a primary key-foreign key, PK-FK, pair of a superset of PK-FK pairs based at least on a data type and a length of the columns of the superset of PK-FK pairs, wherein the threshold value is further based on a standard principle of FK column and on an analysis of a data type and a length of columns of the superset of PK-FK pairs; eliminating columns which cannot be part of FK from all the tables in the selected schema based on the standard rules; generating a sub-set of PK-FK pairs by comparing the computed threshold value with a predefined threshold value, wherein the subset of PK-FK pairs is a subset of the superset of PK-FK pairs, and wherein the predefined threshold value is indicative of an acceptance criterion of the PK-FK pairs from the super-set of PK-FK pairs to form the sub-set of PK-FK pairs; computing a cumulative probability distribution, CPD, for each of PK and FK values in the sub-set of PK-FK pairs based on PK and FK columns; determining a conformance score for each of the PK-FK pairs of the subset of PK-FK pairs, wherein the conformance score is maximum difference between computed corresponding Cumulative Probability Distribution, CPD, values of PK and CPD of FK for each PK-FK pair of the sub-set of PK-FK pairs and wherein the conformance score is computed with respect to a range and a variation for the sub-set of PK-FK pairs; comparing the conformance score of the each PK-FK pair of the sub-set of PK-FK pairs with a predetermined acceptability index, wherein the predetermined acceptability index is indicative of an acceptance of at least one positive FK from the set of PK-FK pairs, wherein the FK identification involve further analysis of rows of data and hence removal of false-positives FK results in use of less processing power, saving in time and effort; and storing the identified FK in a memory and presented in a report format using an interface.