如何使用ASP在SQL中创建Database和Table，并能增加／修改／删除字段

[cpunion]

如何使用ASP在SQL中创建Database和Table，并能增加／修改／删除字段

[xuchu]

dim conn
dim rs
set conn=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
conn.open connstring
rs.open "create datebase dbname...",conn,2,3,1
rs.open "create table tbname...",conn,2,3,1
...

[希偌]

set conn=server.createobject("adodb.connection")
conn.open "…………………………"
conn.Execute "create table tablename(fieldname typename)"'增加table
conn.Execute "alter table tablename add(field typename)"'增加字段
……………………………………………………
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]

alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
or ADD INDEX [index_name] (index_col_name,...)
or ADD PRIMARY KEY (index_col_name,...)
or ADD UNIQUE [index_name] (index_col_name,...)
or ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
or CHANGE [COLUMN] old_col_name create_definition
or MODIFY [COLUMN] create_definition
or DROP [COLUMN] col_name
or DROP PRIMARY KEY
or DROP INDEX index_name
or RENAME [AS] new_tbl_name
or table_options