Working with MyLittleAdmin - Management Tool for SQL Server 2005
page 6 of 20
by Bilal Haidar
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 83224/ 149


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.

View Entire Article

User Comments

Title: Remote Machine Problem   
Name: Utsab
Date: 2012-01-29 8:17:14 AM
It tells how to configure the tool for own machine or local machine. But in case of remote machine how to access the database with this MyLittleAdmin?
Title: sql server   
Name: kashif masood
Date: 2009-10-23 9:36:44 AM
Excellent work and very descriptive specially with all those screenshots
Title: Working with MyLittleAdmin - Management Tool for SQL Server 2005   
Date: 2007-02-23 11:37:42 AM
Excellent work and very descriptive specially with all those screenshots.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-05-27 8:30:47 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search