Executes provider specific sql query on given connection. The code will be executed directly on provider database, therefore it must be written in SQL dialect specific to given connection. For example, if @connection_name is a name of Oracle connection, then @sql should use Oracle dialect of SQL instead of T-SQL.



Connection name that will be used to execute given SQL code.


Provider specific SQL code.


Drops a table on Oracle using Lyftron connection.

EXEC lyft_execute_provider_sql_on_connection @connection_name = 'OracleConnection', @sql='DROP TABLE list_customers PURGE;';

Notice the PURGE clause, that is specific to Oracle and not present in T-SQL.

See Also