Duda con truncate.

[gnzsoloyo]

Si eso devuelve sólo esas dos tablas, entonces hay que probar:

Código MySQL:

SELECT DISTINCT
  K.TABLE_SCHEMA,
  K.TABLE_NAME
FROM
  information_schema.KEY_COLUMN_USAGE K INNER JOIN
  information_schema.TABLE_CONSTRAINTS T USING(TABLE_SCHEMA, TABLE_NAME)
WHERE
  T.CONSTRAINT_TYPE = 'FOREIGN KEY' AND
  K.REFERENCED_TABLE_NAME = 'reglasxrpiedades';
 

Y además:

Código MySQL:

SELECT DISTINCT
  K.TABLE_SCHEMA,
  K.TABLE_NAME
FROM
  information_schema.KEY_COLUMN_USAGE K INNER JOIN
  information_schema.TABLE_CONSTRAINTS T USING(TABLE_SCHEMA, TABLE_NAME)
WHERE
  T.CONSTRAINT_TYPE = 'FOREIGN KEY' AND
  K.REFERENCED_TABLE_NAME = 'preguntas';