CODEWITHSUNDEEP
sql-server-2008ssms
Marc Andreson
Marc Andreson

Reputation: 3495

Server Management Studio visual editor

Is there any way to add/edit/remove rows in MS SQL Server Management Studio as it is possible with phpMyAdmin ? I mean is there any gui to list rows, edit them and add, or do I have to do all operations using SQL syntax?

Upvotes: 0

Views: 124

Answers (2)

Joe Alfano
Joe Alfano

Reputation: 10299

If you want to edit or delete specific rows in a table, not just the top 200 rows, right-click on the Views folder and select "New View...". In the View Designer pane, add the table you want to work with, and set the criteria you want to filter by. When you click the execute button, the returned rows will appear in an editable grid, where you can edit or delete them using an excel-like interface.

Upvotes: 0

Jason Dam
Jason Dam

Reputation: 400

You can do this in Object Explorer. Expand the Databases, database, table, then Edit Top 200 rows. If you want more rows, I believe you can edit the Top property in the right window.

If you need more direct table editing, I think Access might be an alternative.

Upvotes: 1

Related Questions