How to delete a record in an SQL Database database

Discover step-by-step instructions to delete a record in an SQL Database database for efficient data management.

View as Markdown

This guide demonstrates how to use Azion SQL Database to delete a record in your database using the Azion API.

Deleting a record

Run the following POST request in your terminal, replacing [TOKEN VALUE] with your personal token and {id_database} with the ID of the database from which you want to delete the record:

curl --location --request POST 'https://api.azion.com/v4/edge_sql/databases/{id_database}/query' \
--header 'Authorization: Token <token_value>' \
--header 'Content-Type: application/json' \
--data-raw {
"statements": [
"delete from users where name = '\''name'\'' "
]
}

You should receive a response indicating the success or failure of the operation.