Delete Account

Select Delete Account to provide an SQL query or stored procedure to delete an account. Enter the SQL query or stored procedure into the SQL Query or Stored Procedure field as appropriate.

SQL Query

The SQL query format is as follows:

DELETE FROM DatabaseName.dbo.[TableName]

WHERE AccountID = $plan.nativeIdentity$;

Stored Procedure

The stored procedure format is as follows:

EXEC StoredProcedureName @VariableName =

$plan.nativeIdentity$;

Use Case Examples

SQL Query

DELETE FROM HR.dbo.[Employee] WHERE empid =

$plan.nativeIdentity$;

Stored Procedure

EXEC HR.dbo.DeleteEmployee @EmpID =

$plan.nativeIdentity$;