Darshan Hiranandani : What SQL command should I use to delete a row from a database?

Integrations
1

Hello everyone,

I’m Darshan Hiranandani, trying to delete a row from a database but I’m not entirely sure of the correct approach. Could anyone provide suggestions on how to properly delete a specific row?

I’d appreciate any guidance, such as the SQL query to use or any other methods depending on the type of database.

Thanks in advance for your help!
Regards
Darshan Hiranandani

2

Good morning @darshanhiranandani23,

It’s possible to delete a table row using SQL, as under the hood a Baserow table is simply a Postgresql table, but I recommend you don’t as there can be unintended side effects.

I suggest two different, non-SQL-based, paths you can take to delete your row:

  1. Using the UI, by right-clicking on a row and clicking “Delete row”, or
  2. Programmatically with using the API.

I hope this helps.

Cheers,
Peter Evans