You can see both of these as options when you right-click on a table in the Object Explorer, but only the edit option allows for editing the rows. Note, once you have an edit window open there will be a square button that says "SQL" on it (the "Show SQL Pane" button)at the upper left that you may click to expose the select query for editable rows. Ctrl-3 toggles this pane open and closed too. You may edit the SQL and then press an "Execute SQL" button that is three icons to the right of the "Show SQL Pane" button to make the rows update. Ctrl-R does the trick too. The "Execute SQL" button's icon is a rightward pointing blue arrow (well, triangle... like a "Play" icon) by two overlapping database tables.
No comments:
Post a Comment