delete_row
Remove specific database records by primary key value from SQL Server tables to maintain data integrity and manage storage.
Instructions
Delete a row by primary key.
Args:
table: Table name (can include schema: 'dbo.Users' or 'Users')
id: Primary key value of the row to delete
Returns:
Dictionary with:
- status: 'deleted' or error
- table: Full table name
- id: The deleted row's ID
- rows_affected: Number of rows deleted (should be 1)Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||