Clever Geek Handbook

How to open a Sql2008 table

I want to open a table by Enterprise Manager Sql 2008 interface

As with Enterprise Manager Sql2005 interface, right-click and click Open Table.

0


source to share


2 answers


Right click on the relevant table and select "Edit Top 200 Rows".

"200" is configured in the Tools \ Options dialog under "SQL Server Object Explorer"



Changing the value for the Value for the Edit Top Row Commands command to 0 will return all rows for editing, similar to Open Table in SSMS 2005.

You can also use Ctrl + 3 to display the underlying SQL after selecting "Edit Top 200 Rows" and manually modify the query to customize which rows are displayed for editing.

+2


source


I think this feature has been removed. Try the "Edit top 200 rows" command. It will do the same, but not fetch every row of a (potentially) huge table.



0


source






More articles:


All Articles