⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 441.html

📁 Jsp001精华文章离线版.很不错的,主要是针对JSP的相关内容的
💻 HTML
字号:
🔍 

<STYLE type=text/css>
<!--
body,td { font-size:9pt;}
hr { color: #000000; height: 1px}
-->
</STYLE>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD><TITLE>FAQ汇萃 >> SQL之家 >> 用SQL如何建立表？</title>
</head>
<body >

<p><IMG SRC="../image/jsp001_middle_logo.gif" WIDTH="180" HEIGHT="60" BORDER=0 ALT=""></p>

<table width=100% bgcolor="#cccccc" align=center cellpadding="2" cellspacing="0" border=1 bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#EFF8FF"><td>
<a href=http://www.jsp001.com/list_thread.php?int_attribute=1>FAQ汇萃</a>
>> <a href=http://www.jsp001.com/list_thread.php?forumid=45&int_attribute=1>SQL之家</a>
>> 用SQL如何建立表？ [<a href=http://www.jsp001.com/forum/showthread.php?goto=newpost&threadid=441>查看别人的评论</a>]<br>

<hr><p>由 amtd 发布于: 2001-02-14 09:55</p><p><img src="images/icons/icon1.gif" alt="Post" border=0> </p><p>CREATE TABLE statement                                                           <br>  Creates a new table.                                                             <br>                                                                                   <br>  CREATE TABLE [&lt;database&gt;.[&lt;owner&gt;].]&lt;table_name&gt;                              <br>                                                                             <br>       {&lt;col_name&gt; &lt;column_properties&gt; [&lt;constraint&gt; [&lt;constraint&gt;                 <br>            [... &lt;constraint&gt;]]]                                                   <br>       | [[,] &lt;constraint&gt;]}                                                       <br>            [[,] {&lt;next_col_name&gt; |                                                <br>            &lt;next_constraint&gt;}...]                                                 <br>                                                                                   <br>  [ON &lt;segment_name&gt;]                                                              <br>                                                                                   <br>  &lt;column_properties&gt; =                                                            <br>       &lt;datatype&gt; [NULL | NOT NULL | IDENTITY[(&lt;seed&gt;, &lt;increment&gt;)]]              <br>  &lt;constraint&gt; =                                                                   <br>    For a PRIMARY KEY constraint:                                                  <br>       [CONSTRAINT &lt;constraint_name&gt;]                                              <br>            PRIMARY KEY [CLUSTERED | NONCLUSTERED]                                 <br>                 (&lt;col_name&gt; [, &lt;col_name2&gt; [..., &lt;col_name16&gt;]])                  <br>                 [ON &lt;segment_name&gt;]                                               <br>    For a UNIQUE constraint:                                                       <br>       [CONSTRAINT &lt;constraint_name&gt;]                                              <br>            UNIQUE [CLUSTERED | NONCLUSTERED]                                      <br>                 (&lt;col_name&gt; [, &lt;col_name2&gt; [..., &lt;col_name16&gt;]])                  <br>                 [ON &lt;segment_name&gt;]                                               <br>    For a FOREIGN KEY constraint:                                                  <br>       [CONSTRAINT &lt;constraint_name&gt;]                                              <br>            [FOREIGN KEY (&lt;col_name&gt; [, &lt;col_name2&gt;                                <br>                 [..., &lt;col_name16&gt; ]])]                                           <br>                 REFERENCES [&lt;owner&gt;.]&lt;ref_table&gt; [(&lt;ref_col&gt;                      <br>                 [, &lt;ref_col2&gt; [..., &lt;ref_col16&gt;]])]                               <br>    For a DEFAULT constraint:                                                      <br>       [CONSTRAINT &lt;constraint_name&gt;]                                              <br>            DEFAULT {&lt;constant_expression&gt; | &lt;niladic-function&gt; | NULL}            <br>                 [FOR &lt;col_name&gt;]                                                  <br>    For a CHECK constraint(s):                                                     <br>       [CONSTRAINT &lt;constraint_name&gt;]                                              <br>            CHECK [NOT FOR REPLICATION] (&lt;expression&gt;)                             <br> <br> <br><br>__________________<br><font color=red>真实源于生活！ </font><br>请访问我们的网站： <br>（VB爱好者乐园） <br><a href="http://www.vbgood.com" target=_blank>http://www.vbgood.com</a><br><a href="http://www.d1vb.com" target=_blank>http://www.d1vb.com</a><br><a href="http://61.128.97.225/vbgood/index.asp" target=_blank>http://61.128.97.225/vbgood/index.asp</a><br>拥有1800多个资料！ </p></td>
  </tr>
</table>

<p>
<CENTER><a href="http://www.jsp001.com/forum/newreply.php?action=newreply&threadid=441">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>6</font> 分，你认为它对你有帮助吗？
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=441&intVote=4","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>非常多</a>](<font color=red>1</font>) 
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=441&intVote=2","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>有一些</a>](<font color=red>1</font>) 
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=441&intVote=1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>无帮助</a>](<font color=red>1</font>) 
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=441&intVote=-1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>是灌水</a>](<font color=red>1</font>) </p>
<script language="javascript" src="http://www.jsp001.com/include/read_thread_script.php?threadid=441"></script>
<p><CENTER>
Copyright &copy; 2001 - 2009 JSP001.com . All Rights Reserved <P>

<IMG SRC="../image/jsp001_small_logo.gif" WIDTH="85" HEIGHT="30" BORDER=0 ALT="">
</CENTER></p>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -