View the Contents of a Table in a SQL Server Database Using Enterprise Manager

How to View a Table in a SQL Server Database 

Need to know how you can view a table within a SQL server database? Using the Enterprise Manager, this can be achieved with just a few simple steps.

  1. First, you’ll need to open Enterprise Manager and expand the registered SQL Server
  2. Expand Databases to see a list of databases on the server
  3. Locate and expand the specific database containing the table you wish to view
  4. Click on Tables, which will show all of the tables in the database in the pane to the right
  5. Locate the table you’d like to open, right-click it and select Open Table -> Return Top…
  6. Type the number of rows you would like to view and click OK
  7. If you would like to view all rows in the table, select the Return All Rows option instead

And there you have it!


Additional Links:

Looking for more information on SQL Server? Search our Knowledge Base!  

In need of more great content? Interested in cPanel, Private Cloud, or Colocation? Check out our recent posts for more news, guides, and industry insights!

Share on Twitter
Share on Facebook