CODEWITHSUNDEEP
sqlsql-serverazure
Adam Lee
Adam Lee

Reputation: 576

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).

enter image description here

Upvotes: 0

Views: 2570

Answers (1)

PunitSharma
PunitSharma

Reputation: 93

You can edit row on double click. On Azure portal follow these steps. enter image description here

  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). enter image description here
  4. select Preview terms check box, then click ok. enter image description here
  5. Double click on row , edit row enable. enter image description here
  6. Change on FirstName from Punit to Sunit. Click top menu Save button and its save record to database. enter image description here
  7. Final result. enter image description here

Upvotes: 1

Related Questions