Knowledgebase


Portal Home > Knowledgebase > General > View the contents of a table in a SQL Server database using Enterprise Manager?

View the contents of a table in a SQL Server database using Enterprise Manager?

Open Enterprise Manager and expand the registered SQL Server

Expand Databases

Expand the database

Click on Tables, all of the tables in the database will show up in the right pane

Locate the table you’d like to open, right-click it and select Open Table -> Return Top…

Type the number of rows you would like to view, click OK

If you would like to view all rows in the table, select the Return All Rows option.


Also Read