If you expand the Tables node under the currently selected database would list all the tables included in the database. As you can see clicking on a table (tbh_Articles, Figure 3) opens a set of new options on the right-hand side window. The name and path of the table is displayed in the header section. Below the header section you can see several icons. The icons are: Open Table, Modify, View Dependencies, Properties, Permissions, and Extended Properties respectively.

Clicking on any icon will redirect you to a new screen with a new set of icons that help you control the table. For instance, clicking on Modify icon show the following screen

Figure 5

This screen allows you to modify the structure of the table, adding, editing, and deleting columns. Clicking the Edit icon beside the ArticleID column shows the following screen

Figure 6

You are being redirected to a new screen that allows you to edit the ArticleID properties (allow nulls, Data Type, etc …)

Notice the black arrow drown on the figure above. This arrow points to an icon called Script. Clicking this icon allow you to edit the column properties using a TSQL Script as follows

Figure 7

Other options to mention on the Modify screen are the following three little icons:

Figure 8

The first icon allows you to go one level up, in this case back to the main screen that was shown when you clicked on a tbh_Articles table.

The second icon allows you to refresh the column and this is useful if you have made any changes to the column.

The third and last icon allows you to synchronize the changes on the column if any among all other database objects that reference this column.

The above three icons will notice them every where while using the myLittleAdmin tool.

The last feature to discuss on the Modify screen is the icon pointed to by a black arrow. This icon allows you to create a new column and add it to the currently viewed table.