access中建表,增加,删除和修改字段属性语句.txt

较为详细的介绍了asp自定义的各种函数,方便asp的各种开发.

ACCESS中建表,增加,删除和修改字段属性语句
ACCESS中增加和修改字段属性语句
建立表语句
sql="CREATE table tablename (id int IDENTITY (1, 1) NOT NULL,"&_
  "columnname varchar(50) null,"&_
  "columnname int default 0,"&_
                     .................................
  "columnname text,"&_
  "columnname datetime default Now())"
conn.execute(sql) 

增加表中字段:
conn.execute("alter table tablename add id  int IDENTITY (1, 1) NOT NULL ") 'ID自动编者编号
conn.execute("alter table tablename add 字段名 bit") '是与否
conn.execute("alter table tablename add 字段名 varchar(250)") '文本长度250
conn.execute("alter table tablename add 字段名 int default 0") '长整默认0
conn.execute("alter table tablename add 字段名text") '备注
conn.execute("alter table tablename add 字段名 datetime default Now()")  '时间默认now()
conn.execute("alter table tablename add 字段名 image")  'ole对象
conn.execute("alter table tablename add 字段名 money") '货币

修改表中字段
conn.execute("alter table tablename alter column id  int IDENTITY (1, 1) NOT NULL") '修改为ID自动编者编号
conn.execute("alter table tablename alter column columnname bit") '修改为是与否
conn.execute("alter table tablename alter column columnname varchar(250)") '修改为文本长度250
conn.execute("alter table tablename alter column columnname int default 0") '修改为长整默认0
conn.execute("alter table tablename alter column columnname text") '修改为备注
conn.execute("alter table tablename alter column columnname datetime default Now()")  '修改为时间默认now()
conn.execute("alter table tablename alter column columnname image")  '修改为ole对象
conn.execute("alter table tablename alter column columnname money")  '修改为货币

删除表中的字段
conn.execute("alter table tablename drop columnname")