How to: Show Data from a Table (Visual Database Tools)
You can view the contents of any table using Object Explorer.
To view the contents of a table
In Object Explorer, right-click the table with data you want to view and choose Open Table.
The table's data opens in a grid.