Methods and apparatuses are described for enforcing referential integrity of database columns across a plurality of tables in a database. A server periodically captures a database schema comprising relationships between a primary key column in a first table and a foreign key column in a second table. The server executes a first procedure call to determine a discrepancy between the primary key column and the foreign key column with respect to a data length value or a data type value. The server executes database queries against data in the first table or second table to confirm the discrepancy. The server executes a second procedure call to change the data length value or the data type value. After the second procedure call finishes, the data length value and the data type value of the primary key column and the foreign key column match.