You guys Continuing from our last video where we did a few SQL commands to delete some records, we will look at how we can go about deleting records using the editor itself. So if we right click our table and once again go to Edit top 200 rows from this view, you can actually select the row that you would like to remove and go ahead and right click and press delete or just press Delete on your keyboard. So we can go about removing student number 11 and we just press Delete and at least here it will ask Are you sure you want to delete these rules so you can just click Yes, and then it will do the script in the background and readjust accordingly. A script is a nice automated way to effect multiple changes multiple times but by writing it one time, however, if you use the editor and you had a million rows, it would be a bit more difficult to comb through these rows to find the one that you want to delete or you could actually just modify the SQL statement to find the exact rules that you want to delete.

And then you could just select them all and press Delete. It's a matter of which one is more efficient to do remember that scripts are actually shareable. So if you do it on your machine, you can share with somebody else who may have the same problem or need as you do with their database.