SELECT
*
FROM
information_schema.triggers
WHERE
trigger_schema = 'abc'
SELECT
CONCAT('DROP TRIGGER IF EXISTS ',trigger_name,' ON ',trigger_schema,'.',event_object_table,';') AS sql
FROM
information_schema.triggers
WHERE
trigger_schema = 'abc'
Subscribe to:
Post Comments (Atom)
Airflow - DAG Dependencies
Define the order in which tasks should run Tasks can be upstream (run before) or downstream (run after) Declared after creating the tasks Me...
-
MD5 (Message Digest Function) is a hash function in Informatica which is used to evaluate data integrity. The MD5 function uses Message-Dig...
-
Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
-
Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
No comments:
Post a Comment