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
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
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
Other options to mention on the Modify screen are the following
three little icons:
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
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
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.