CODEWITHSUNDEEP
sql-server-2008
Rasha
Rasha

Reputation:

How to open Sql2008 Table

I want To open Table By Sql 2008 Enterprise Manager Interface

As in Sql2005 Enterprise Manager Interface by Right Click then Click open Table.

Upvotes: 0

Views: 8089

Answers (2)

BlackMael
BlackMael

Reputation: 3208

Right-click on the table in question and select "Edit Top 200 Rows".

The "200" is configurable from the Tools\Options dialog under "SQL Server Object Explorer"

Changing the value for "Value for Edit Top Rows command" to 0 will return all rows for editing in a similar manner 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 change the query to customize which rows are show for editing.

Upvotes: 2

Eyvind
Eyvind

Reputation: 5261

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.

Upvotes: 0

Related Questions