Everything about database,how to,example,guide,

Chart is the object of a kind of database with peculiar SQL Server,The way that it offers the administrative database with intuitionistic user to express.Through chart,The user is founded OK and intuitionisticly, editor database expresses the concern between,The attribute that also can edit a watch to reach its to list.
The move that establishs chart in Enterprise Manager is as follows:
(1) choose in Enterprise Manager " Diagrams " ,Click right key,Choose from inside quick menu " New Database Diagram " option,Can move found database chart guide,Place of the 8-23 that be like a graph is shown.,


(2) click " next " pushbutton,The choice that if place of graph 8-24 is shown,can appear namely includes the database in chart to express a dialog box,Among them pitch on " Add Related Tables Automatically " after option,When adding a table in chart,The system will be added automatically in chart with its related watch.


(3) click " next " pushbutton,The end chart that if place of graph 8-25 is shown,can appear namely establishs a dialogue,Casing listed the database that is about to use at founding chart is expressed among them.


(4) click " finish " pushbutton,The editor chart dialog box that if place of graph 8-26 is shown,can appear namely.

In editing chart dialog box,Establish the relationship between the watch special forthright,Need only from advocate crucial field chooses in the watch,Press mouse right key not to put direct and mobile mouse to again from the corresponding field of the watch,Loose mouse can.For example,Establish the relationship between watch Orders and watch Order_firm,Those who if place of graph 8-27 is shown,appear is meet found relation dialog box namely after making this operation.Amid can be installed to concerning.


(5) pushbutton is clicked in tool column,Save chart.The chart target that if place of graph 8-28 is shown,can appear namely in Enterprise Manager.


Right key is clicked on chart target,Choose from inside quick menu " Design Diagram " option,The chart that can appear to found dialog box likeness with chart namely edits a dialog box,But amid edits chart target,Also can edit corresponding watch and its field, index, tie and other attribute to wait.

This chapter brief summary:
A kind of construction that index even if can accelerate data retrieval.Understanding is founded with what master index with management,Very helpful to learn and undertaking data inquires.