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

Table Objects

Going back to Figure 4, you can see a list of folders each corresponding to items contained within a table.

Table Columns

Clicking the Columns folder would open up a new screen listing all the columns contained in the current table. Each column displayed upon clicking on it, a context-menu opens giving you several options among which is adding a new column, modifying the currently clicked column, renaming the column name, showing properties and extended properties.

Table Keys

If you click on Keys folder you get all the keys defined on the currently selected table such as foreign keys and primary keys:

Figure 9

Clicking on the first key which happens to be a foreign key in this table pops a context-menu which contains several options you can choose from among which is the Modify option, clicking the Modify option shows the following screen

Figure 10

You can easily change the columns associated with the foreign key selected, change the tables involved and then save your changes.

The context-menu that pops up in Figure 8 above allows you also to create a new foreign key.

Going back to Figure 8, clicking on any primary key would also pop up a new context-menu which provides a set of actions that can be triggered on a primary key among which is Modify option. Clicking this option shows the following screen

Figure 11

As you can see in the figure above you can modify the primary key by adding/removing columns that constitute the primary key.

Table Constraints

The third folder listed in Figure 4 above is the Constraints folder. Clicking on this folder shows all the constraints defined on the table. For instance a constraint can be a simple rule that fills a column with a default value when a new row is added to the table. Clicking on any constraint would pop-up a context-menu that allows you to add a new constraint, rename the current one and other useful options.

Table Triggers

The fourth folder shown in Figure 4 above is the Triggers folder. Clicking this folder lists all the triggers defined on the currently selected table. You can modify an existing trigger, add a new trigger and much more options. Notice here when creating a new trigger your only option is TSQL for constructing the trigger.

Table Indexes

The fifth folder shown in Figure 4 above is the Indexes folder. This folder lists all indexers defined on the currently selected table. You can manage indexes by adding new opens, renaming old ones, and checking their properties and extended properties.

Table Statistics

The last folder shown in Figure 4 above is the Statistics folder. Statistics in SQL Server 2005 refers mainly to information that the server collections about the distribution of Data in columns and indexes. To learn more about Statistics in SQL Server 2005, check this article: Basics of Statistics in SQL Server 2005.


View Entire Article

User Comments

Title: Remote Machine Problem   
Name: Utsab
Date: 2012-01-29 8:17:14 AM
Comment:
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
Comment:
Excellent work and very descriptive specially with all those screenshots
Title: Working with MyLittleAdmin - Management Tool for SQL Server 2005   
Name: arindam1802@yahoo.com
Date: 2007-02-23 11:37:42 AM
Comment:
Excellent work and very descriptive specially with all those screenshots.






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


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-12-04 5:27:14 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search