?? 6348.htm
字號(hào):
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>MS SQL基礎(chǔ)教程:創(chuàng)建和使用圖表 - 編程入門網(wǎng)</title>
<meta name="keywords" content="MS SQL基礎(chǔ)教程:創(chuàng)建和使用圖表">
<meta name="description" content="MS SQL基礎(chǔ)教程:創(chuàng)建和使用圖表">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/images/style.css" rel="stylesheet" type="text/css" />
<script src="/js1/head.js"></script>
</head>
<body leftmargin="0" topmargin="0" bgcolor="#efefef" oncopy=nocopy()>
<TABLE width="760" cellPadding="0" cellSpacing="0" bgcolor="#eff7fe" align="center">
<TR>
<TD><a href="/index.htm"><img src="/images/logo1.gif" width="150" height="60" border="0"></a></TD>
<TD width="470" align="right"><script src="/js1/top.js"></script></TD>
<TD width="125" align="center"><script src="/js1/topsy.js"></script></TD>
</TR>
</TABLE>
<table width="760" border="0" cellpadding="1" cellspacing="0" class="bklan" align="center">
<tr>
<td align="center" bgcolor="#eff7fe" height="24"> | <a href='/Programming/index.htm'>編程語言</a> | <a href='/webkf/index.htm'>web開發(fā)</a> | <a href='/data/index.htm'>數(shù)據(jù)庫</a> | <a href='/Network/index.htm'>網(wǎng)絡(luò)技術(shù)</a> | <a href='/OS/index.htm'>操作系統(tǒng)</a> | <a href='/Servers/index.htm'>服務(wù)器</a> | <a href='/web/index.htm'>網(wǎng)頁設(shè)計(jì)</a> | <a href='/Design/index.htm'>圖形設(shè)計(jì)</a> | <a href='/Office/index.htm'>辦公軟件</a> | <a href='/soft/index.htm'>常用軟件</a> | <a href='/shadu/index.htm'>殺毒頻道</a> | <a href='/PC/index.htm'>學(xué)電腦</a> |</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="760" align="center" bgcolor="#ffffff" border="0">
<tr>
<td align="center"><script src="/js1/content1.js"></script></td>
</tr>
</table>
<table width="760" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td height="25" background="/templets/img/31bg3.gif" align="left" class="guidet"> → 當(dāng)前位置:<a href='http://www.bianceng.cn/'>首頁</a>→<a href='/data/index.htm'>數(shù)據(jù)庫</a>→<a href='/data/SQLServer/index.htm'>SQL Server</a>→<a href='/data/SQLServer/jc/index.htm'>SQL Server教程</a>→正文</td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top" class="guidet" width="595"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="ct">
<tr>
<td align="center" valign="middle" class="til"><h3> MS SQL基礎(chǔ)教程:創(chuàng)建和使用圖表 </h3>
發(fā)布時(shí)間：2007-12-25 來源：網(wǎng)絡(luò)/責(zé)編：編程入門 作者：佚名<br />
<script src="/js1/468.js"></script>
</td>
</tr>
<tr>
<td style="font-size:14px" align="left" class="til"><table border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><script src="/js1/300.js"></script></td>
</tr>
</table><p> 圖表是SQL Server 特有的一種數(shù)據(jù)庫對(duì)象，它提供給用戶直觀的管理數(shù)據(jù)庫表的方式。通過圖表，用戶可以直觀地創(chuàng)建、編輯數(shù)據(jù)庫表之間的關(guān)系，也可以編輯表及其列的屬性。</p>
<p> 在Enterprise Manager 中創(chuàng)建圖表的步驟如下：</p>
<p> （1） 在Enterprise Manager 中選擇“Diagrams”， 單擊右鍵，從快捷菜單中選擇“New Database Diagram” 選項(xiàng)，就會(huì)運(yùn)行創(chuàng)建數(shù)據(jù)庫圖表向?qū)В鐖D8-23所示。，</p>
<p> <img onclick="get_larger(this)" alt="" src="/upimg/071226/11b61220b201Q15.gif" /></p>
<p> （2） 單擊“下一步”按鈕，即會(huì)出現(xiàn)如圖8-24 所示的選擇包含在圖表中的數(shù)據(jù)庫表對(duì)話框，其中選中“Add related tables automatically” 選項(xiàng)后，當(dāng)添加一個(gè)表到圖表中時(shí)，系統(tǒng)自動(dòng)將與其有關(guān)聯(lián)的表添加到圖表中。</p>
<p> <img onclick="get_larger(this)" alt="" src="/upimg/071226/11b612210S022608.gif" /></p>
<p> （3） 單擊“下一步”按鈕，即會(huì)出現(xiàn)如圖8-25 所示的結(jié)束圖表創(chuàng)建對(duì)話，框其中列出了即將用于創(chuàng)建圖表的數(shù)據(jù)庫表。</p>
<p> <img onclick="get_larger(this)" alt="" src="/upimg/071226/11b61221191036322.gif" /></p>
<p> （4） 單擊“完成”按鈕，即會(huì)出現(xiàn)如圖8-26 所示的編輯圖表對(duì)話框。</p>
<p> <img onclick="get_larger(this)" alt="" src="/upimg/071226/11b61221293042I1.gif" /></p>
<p> 在編輯圖表對(duì)話框中，創(chuàng)建表之間的關(guān)系特別簡捷，只需從主表中選擇關(guān)鍵字段，再按住鼠標(biāo)右鍵不放直接移動(dòng)鼠標(biāo)到從表的相應(yīng)字段上，松開鼠標(biāo)即可。例如，創(chuàng)建表orders和表order_firm 之間的關(guān)系，作此操作后即會(huì)出現(xiàn)如圖8-27 所示的創(chuàng)建關(guān)系對(duì)話框。在其中可對(duì)關(guān)系作設(shè)置。</p>
<p> <img onclick="get_larger(this)" alt="" src="/upimg/071226/11b612213a053536.gif" /></p>
<p> （5） 在工具欄中單擊按鈕，保存圖表。在Enterprise Manager 中即會(huì)出現(xiàn)如圖8-28 所示的圖表對(duì)象。</p>
<p> <img onclick="get_larger(this)" alt="" src="/upimg/071226/11b612214c0D355.gif" /></p>
<p> 在圖表對(duì)象上單擊右鍵，從快捷菜單中選擇“Design Diagram” 選項(xiàng)，即會(huì)出現(xiàn)同圖表創(chuàng)建對(duì)話框相似的圖表編輯對(duì)話框，可在其中編輯圖表對(duì)象，也可以編輯相應(yīng)的表及其字段、索引、約束和其它屬性等。</p>
<p> 本章小結(jié)：</p>
<p> 索引就是可以加快數(shù)據(jù)檢索的一種結(jié)構(gòu)。理解和掌握索引的創(chuàng)建與管理，對(duì)于學(xué)習(xí)和進(jìn)行數(shù)據(jù)查詢很有幫助。</p>
<p> <a href="/data/SQLServer/jc/200712/6352.htm">查看全套"MS SQL入門基礎(chǔ)教程"</a></p><center><br /><script src="/js1/4682.js"></script></center>
<p>上一篇：<a href='/data/SQLServer/jc/200712/6347.htm'>MS SQL基礎(chǔ)教程:索引調(diào)整向?qū)?lt;/a> 下一篇：<a href='/data/SQLServer/jc/200712/6349.htm'>MS SQL基礎(chǔ)教程:數(shù)據(jù)完整性概述</a> </p></td>
</tr>
<tr>
<td align="left" style="font-size:14px;" height="25"><IMG src="/images/t0.gif" width="12" height="12" align=absMiddle><strong>相關(guān)文章</strong><br /><table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6347.htm">MS SQL基礎(chǔ)教程:索引調(diào)整向?qū)?lt;/a><br/>
</td>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6349.htm">MS SQL基礎(chǔ)教程:數(shù)據(jù)完整性概述</a><br/>
</td>
</tr>
<tr>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6346.htm">MS SQL基礎(chǔ)教程:刪除索引</a><br/>
</td>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6345.htm">MS SQL基礎(chǔ)教程:查看與修改索引</a><br/>
</td>
</tr>
<tr>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6351.htm">SQL Server與Access、Excel的數(shù)據(jù)轉(zhuǎn)換</a><br/>
</td>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6344.htm">MS SQL基礎(chǔ)教程:創(chuàng)建索引</a><br/>
</td>
</tr>
<tr>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6352.htm">MS SQL Server入門教程</a><br/>
</td>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6343.htm">MS SQL基礎(chǔ)教程:數(shù)據(jù)庫索引</a><br/>
</td>
</tr>
<tr>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6353.htm">對(duì)SQL Server進(jìn)行收縮減小日志存儲(chǔ)</a><br/>
</td>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6342.htm">MS SQL基礎(chǔ)教程:SQL表的刪除</a><br/>
</td>
</tr>
<tr>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6354.htm">SQL Server連接基礎(chǔ)知識(shí)</a><br/>
</td>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6341.htm">MS SQL基礎(chǔ)教程:查看表</a><br/>
</td>
</tr>
<tr>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6355.htm">將SQL Server中所有表的列信息顯示出來</a><br/>
</td>
<td width='50%'>
·<a href="/data/SQLServer/jc/200712/6340.htm">MS SQL基礎(chǔ)教程:SQL數(shù)據(jù)庫表的修改</a><br/>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="165" valign="top" class="guideb"><script src="/js1/1601.js"></script><table width="100%" border="0" cellpadding="0" cellspacing="0" valign="top">
<tr>
<td height="25" align="center" background="/templets/img/31bg3.gif"><strong>閱讀排行</strong></td>
</tr>
<tr>
<td>·<a href="/data/SQLServer/jc/200712/6352.htm">MS SQL Server入門教程</a><br/>
·<a href="/data/SQLServer/jc/200807/10974.htm">MS SQL基礎(chǔ)教程:存儲(chǔ)過程</a><br/>
·<a href="/data/SQLServer/jc/200705/1189.htm">sql語言教程</a><br/>
·<a href="/data/SQLServer/jc/200807/10973.htm">MS SQL基礎(chǔ)教程:創(chuàng)建存儲(chǔ)</a><br/>
·<a href="/data/SQLServer/jc/200705/1182.htm">sql字符串函數(shù)</a><br/>
·<a href="/data/SQLServer/jc/200712/6301.htm">MS SQL基礎(chǔ)教程:SQL Serve</a><br/>
·<a href="/data/SQLServer/jc/200712/6302.htm">MS SQL基礎(chǔ)教程:SQL Serve</a><br/>
·<a href="/data/SQLServer/jc/200712/6314.htm">MS SQL基礎(chǔ)教程:數(shù)據(jù)類型</a><br/>
·<a href="/data/SQLServer/jc/200705/1188.htm">Sql語言基礎(chǔ)</a><br/>
·<a href="/data/SQLServer/jc/200712/6311.htm">MS SQL基礎(chǔ)教程:Transact-</a><br/>
·<a href="/data/SQLServer/jc/200712/6312.htm">MS SQL基礎(chǔ)教程:SQL變量</a><br/>
·<a href="/data/SQLServer/jc/200705/1184.htm">sql基本語句</a><br/>
·<a href="/data/SQLServer/jc/200807/10972.htm">MS SQL基礎(chǔ)教程:管理存儲(chǔ)</a><br/>
·<a href="/data/SQLServer/jc/200712/6306.htm">MS SQL基礎(chǔ)教程:數(shù)據(jù)庫基</a><br/>
·<a href="/data/SQLServer/jc/200705/1178.htm">sql數(shù)據(jù)表</a><br/>
</td>
</tr>
<tr>
<td><script src="/js1/1602.js"></script></td>
</tr>
<tr>
<td height="25" align="center" background="/templets/img/31bg3.gif"><strong>最新文章</strong></td>
</tr>
<tr>
<td><script src="/plus/js/0.js" language="javascript"></script></td>
</tr>
</table></td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="760" align="center" bgcolor="#ffffff" border="0">
<tr>
<td align="center"><script src="/js1/content2.js"></script></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr height="26">
<td bgcolor="#e1f0fd" width="48"></td>
<td bgcolor="#6ab3f4" width="35"></td>
<td bgcolor="#0a518f" colspan="2" width="4"></td>
<td bgcolor="#c0c0c0" width="530" align="center"><a title="將本站設(shè)為你的首頁" onclick="this.style.behavior='url(#default#homepage)';this.sethomepage('http://www.bianceng.cn');return false;" href="http://www.bianceng.cn/">設(shè)為首頁</a> | <a class="navmenu"
title="將本站加入到你的收藏夾"
href="javascript:window.external.AddFavorite(location.href,document.title)">加入收藏</a> | <a href="/about/about.htm">關(guān)于本站</a> | <a href="/plus/flink.php">友情鏈接</a> | <a href="/about/banquan.htm">版權(quán)聲明</a> | <a href="/plus/sitemap.html">網(wǎng)站地圖</a> | <a href="/plus/rssmap.html">RSS訂閱</a></td>
<td bgcolor="#0a518f" colspan="2" width="4"></td>
<td bgcolor="#6ab3f4" width="32"></td>
<td bgcolor="#e1f0fd" width="47"></td>
</tr>
<tr height="26">
<td colspan="9" bgcolor="#FFFFFF" align="center">編程入門網(wǎng) 版權(quán)所有,bianceng.cn,All Rights Reserved. <script src="/js/tongji.js"></script> 閱讀次數(shù)：<script src="/plus/count.php?aid=6348&mid=0" language="javascript"></script></td>
</tr>
</table>
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -