Duda con truncate.

[gnzsoloyo]

Perdón creo que te puse al revés la idea:

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 = 'reglaspropiedades ';