Beranda Query Query Cek relasi table / foreign key

Query Cek relasi table / foreign key

Terakhir diperbarui saat Feb 17, 2025
SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = 'migrasi_poltekaisyah' AND REFERENCED_TABLE_NAME IS NOT NULL and REFERENCED_TABLE_NAME ='mahasiswa';