Toad World® Forums

How to edit in Toad for SQL?



I want just add a few data for the fields in my table. I don’t want to run ‘insert’ statement but want to use GUI.

In MS Studio I just select ‘Edit Top 200 rows’ and it allows me to add a new values to fields.

In Toad I also select ‘Object Details’ - ‘Data’ Tab but it does not allow me to modify or add data.

What I’m missing assuming I am using the same table for both clients?



Hi susja,

You’ve already find the right place to edit data. By default, toad set the data grid as read only.

You have to turn on your editing scheme by click the button in below picture(click the button to open custom edit dialog| Check or change your column setting.)

then you can edit or add\delete data by GUI.




All set.