示例代码:
db="db1.mdb"
set conn=server.CreateObject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
sql="CREATE TABLE [news] ("&_
"[news_id] COUNTER CONSTRAINT PrimaryKey PRIMARY KEY,"&_
"[news_title] text(225),"&_
"[news_type] integer DEFAULT 0,"&_
"[news_index] integer DEFAULT 0,"&_
"[news_date] datetime DEFAULT now(),"&_
"[news_content] memo,"&_
"[news_pic] text(255),"&_
"[news_fujian] text(255),"&_
"[depart_id] integer DEFAULT 0,"&_
"[news_author] text(50),"&_
"[news_checkname] text(50),"&_
"[news_check] integer DEFAULT 1,"&_
"[news_order] integer DEFAULT 0,"&_
"[newsclass_id] integer DEFAULT 0,"&_
"[news_link] text(50),"&_
"[news_hit] integer DEFAULT 0,"&_
"[news_english] integer DEFAULT 0,"&_
"[pclass_id] integer DEFAULT 0,"&_
"[news_over] integer DEFAULT 0,"&_
"[news_isnew] integer DEFAULT 0,"&_
"[news_zwlx] text(50) )"
conn.execute sql
说明:
COUNTER CONSTRAINT PrimaryKey PRIMARY KEY 创建自动编号并设为主键;
DEFAULT 为字段设置默认值
常用字段类型:
text:文本
integer:整型
datetime:日期/时间
memo:备注
boolean:是/否
原文链接: http://blog.csdn.net/vince6799/article/details/706787