MS SQL Basics Tutorial: Viewing tables

7.5.1 View the properties of a table

In Enterprise Manager, you right-click the table for which you want to view properties, and select the Properties option from the shortcut menu, the Properties dialog box for the table shown in Figure 7-6 appears, where you can see most of the property information for the table. It should be noted that this property dialog box differs from the one shown in Figure 7-5, with less content and cannot be modified. You can also view and modify the permissions of the table by clicking the "Permissions" button. For permissions settings, see the "Security and User Management" section.

7.5.2 view data in a table

Right-click the table in Enterprise Manager where you want to view the properties, and from the shortcut menu, select Return all rows from the Open Table submenu to display all the data in the table, and the dialog box shown in Figure 7-7 appears.

If you choose return Top ... from the submenu of the Open Table. option, a dialog box appears as shown in Figure 7-8, entering a numeric value representing the number of rows of data rows to view from the first row of the table, and then returning the table's data to the dialog shown in Figure 7-7 as required. You can modify the data in a table or add and delete rows of data in a dialog box.