Enum AdbTableNonQueryOperation

Specifies which (provider-specific) command to create and execute on a table-like object, e.g. a table, view, or table-valued function. Commands are truncate, drop, check if exists, delete rows, etc. Used by AdbTableNonQueryWorker.

Namespace: actionETL.Adb
Assembly: actionETL.dll
Syntax
public enum AdbTableNonQueryOperation

Fields

Name Description
DeleteRows

Execute a (provider-specific) SQL command that deletes all rows in the table-like object.

Note: It does participate in any transaction currently active on the connection.

DropTable

Execute a (provider-specific) SQL command that drops the table.

This operation cannot be rolled back.

DropView

Execute a (provider-specific) SQL command that drops the view.

This operation cannot be rolled back.

IfExistsDropTable

Execute a (provider-specific) SQL command that drops the table if it exists.

Note that executing this command on a view will fail.

This operation cannot be rolled back.

IfExistsDropView

Execute a (provider-specific) SQL command that drops the view if it exists.

Note that executing this command on a table will fail.

This operation cannot be rolled back.

IfExistsError

Execute a (provider-specific) SQL command that errors the worker if the table-like object exists.
IfNotExistsError

Execute a (provider-specific) SQL command that errors the worker if the table-like object doesn't exist.
TruncateTable

Execute a (provider-specific) SQL command that truncates the table.

This operation cannot be rolled back.

See Also