CREATE VIEW CLAVES_AJENAS AS select key_column_usage.table_name,key_column_usage.column_name,key_column_usage.referenced_table_name,key_column_usage.referenced_column_name,referential_constraints.update_rule,referential_constraints.delete_rule from information_schema.key_column_usage join information_schema.referential_constraints where key_column_usage.constraint_name=referential_constraints.constraint_name;