column >
add

create a new column ::
ALTER TABLE [table name] ADD [new Column name][type]

建立一个新栏位

create a new column into an old table at aDB

在aDB下的一数据桌中建立一个新栏位

---------- one way ----------
<%
sql="ALTER TABLE atable ADD C2 varchar(30)"
%>
---------- other way ----------
<%
sql="ALTER TABLE atable ADD C2 varchar(30) 
COLLATESQL_Latin1_General_CP1_CI_AS NULL"
%>
---------------- 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
%>

add a new column C2 to atableC2 length 30