Azure SQL: Modify table data via UI instead of writing SQL query

Is there a way I can modify the table data in an Azure SQL database via some sort of UI (like Excel) instead of having to write SQL queries? Preferably I can modify it online in the Azure Portal instead of having to install some third-party software.

Often times, I just want to edit a specific cell in the table and I feel it would be way easier if I could just double click on that specific cell to edit it instead of having to write a SQL query.

Right now, I am only able to edit data by writing queries, but I can’t actually edit the data in the table by double-clicking (the red box highlighted is uneditable).

Answer

You can edit row on double click. On Azure portal follow these steps.

1. Go to Azure Sql database.
2. Left side menu blade select Query Editor
3. Connect to database. and under Tables folder click table three dot. popup small window open, select Edit Data(Preview).
4. select Preview terms check box, then click ok.
5. Double click on row , edit row enable.
6. Change on FirstName from Punit to Sunit. Click top menu Save button and its save record to database.
7. Final result.