Skip to content

n8n: SQL ​

6 active flows.

Summary ​

FlowTriggerCallsProcsTables
SQL Ontology - Export Functionsschedule: every undefined000
SQL Ontology - Export Indexesschedule: every undefined000
SQL Ontology - Export Stored Proceduresschedule: every undefined000
SQL Ontology - Export Tablesschedule: every undefined000
SQL Ontology - Export Typesschedule: every undefined000
SQL Ontology - Export Viewsschedule: every undefined000

Flows ​

SQL Ontology - Export Functions ​

Loop over each FUNCTION (scalar, inline + multi-statement TVF).\nDefinition is fetched per function inside the loop.

  • Triggers: schedule: every undefined
  • Nodes: 17 · Integrations: SQL, GitHub

SQL Ontology - Export Indexes ​

Loop over each TABLE. Indexes are fetched per table inside the loop.

  • Triggers: schedule: every undefined
  • Nodes: 17 · Integrations: SQL, GitHub

SQL Ontology - Export Stored Procedures ​

Loop over each STORED PROCEDURE.\nDefinition is fetched per procedure inside the loop.

  • Triggers: schedule: every undefined
  • Nodes: 17 · Integrations: SQL, GitHub

SQL Ontology - Export Tables ​

Loop over each TABLE (not column). Column defs are fetched per table inside the loop.

  • Triggers: schedule: every undefined
  • Nodes: 17 · Integrations: SQL, GitHub

SQL Ontology - Export Types ​

Loop over every user-defined type: user-defined TABLE types first, then alias/CLR scalar types.

  • Triggers: schedule: every undefined
  • Nodes: 17 · Integrations: SQL, GitHub

SQL Ontology - Export Views ​

Loop over each VIEW.\nDefinition is fetched per view inside the loop.

  • Triggers: schedule: every undefined
  • Nodes: 17 · Integrations: SQL, GitHub