table >
create

CREATE a SQL data TABLE

建立一SQL数据桌

CREATE TABLE [database.[User_name].[newTableName]
(column_name datatype [identity|constraint|NULL|NOT NULL][...])

视一餐厅为一数据库(one Data Base)
则一餐桌为一资料桌(one Data Table)

CREATE TABLE [User_name].[newTableName] 
([id1] [int] IDENTITY (1, 1) NOT NULL ,
[C1] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_newTableName] 
PRIMARY KEY CLUSTERED ([id1]) ON [PRIMARY] ) ON [PRIMARY]

---------------- SQL server an ASP conn ex:  -----------------
<%

set conn=Server.CreateObject("ADODB.Connection")
conn.open "Provider=SQLOLEDB;Data Source=___ ;
User Id=___;Password=___;Initial Catalog=aDBname;"

Dim sql
sql=request("query")conn.execute sql

%>

在一名为aDBname的数据库内建立一名为
newTableName 的数据桌

You may use a submit form to send the Table Code
 as a request (sql)

Your SQL server will execute to create an data table under

your DB which is ( Initial Catalog=aDBname; ) .

你可运用一表格Form来送出你所编辑的 数据桌
编码你的SQL主机将会执行建立出一个含有自动
计数据笔数 id1 (primary key)与一称之C1的栏