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的欄