qua_execute_provider_sql_on_connection#

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.

Arguments#

connection_name

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

sql

Provider-specific SQL code.

Permissions#

Requires CONTROL CONNECTION permission on the connection or CONTROL SERVER permission.

Example#

Drops a table on Oracle using Querona connection.

EXEC qua_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.