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.
