MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Core (
    id SERIAL PRIMARY KEY,
    title varchar(512),
    kind ENUM('User', 'Organisation', 'Channel', 'Collection', 'Text', 'Picture', 'Sound', 'Video', 'UserGroup'),
    is_activated BOOLEAN DEFAULT true,
    date_created DATETIME DEFAULT CURRENT_TIMESTAMP,
    date_updated DATETIME,
    date_augmented DATETIME,
    author_core BIGINT UNSIGNED NOT NULL,
    FOREIGN KEY (author_core) REFERENCES Core(id) ON DELETE CASCADE
);
CREATE TABLE Test (
  id SERIAL PRIMARY KEY,
  core_id BIGINT UNSIGNED NOT NULL,
  FOREIGN KEY (core_id) REFERENCES Core(id)
);
SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 
WHERE REFERENCED_TABLE_NAME = 'Core' AND TABLE_NAME <> 'Core'


TABLE_NAME
COLUMN_NAME
CONSTRAINT_NAME


Test
core_id
Test_ibfk_1


DROP TABLE IF EXISTS `Core`
Cannot drop table 'Core' referenced by a foreign key constraint 'Test_ibfk_1' on table 'Test'.