利用SQL查询创建Access数据表或者修改字段属性的参考

ALTER TABLE [Things] ADD thingsCOLOR VARCHAR(20) DEFAULT 'Red'
ALTER TABLE [Things] DROP COLUMN thingsType
ALTER TABLE [admin_log1] alter column [admin_name] varchar(2000)

strSQL = "Create table TempCatalog( [OldID] [int] NOT NULL, [NewID] [int] NOT NULL, [OldFatherID] [int] NOT NULL, [NewFatherID] [int] NOT NULL);"

strSQL= "drop table TempCatalog;"

-------------------------------------------------
Access 的数据类型!

文本 nvarchar
备注 ntext
日期/时间 smalldatetime
货币 money
数字 int default 0
自动编号 int IDENTITY (1,1) CONSTRAINT PrimaryKey PRIMARY KEY
是/否 bit
OLE/对象 image
-----------------------------------------------------------

create table TBL_ITEM(itemID int IDENTITY (1,1) CONSTRAINT PrimaryKey PRIMARY KEY,itemName nvarchar(20),itemType nvarchar(3),userName nvarchar(16));

create table TBL_MONEY(moneyID int IDENTITY (1,1) CONSTRAINT PrimaryKey PRIMARY KEY,moneyDate smalldatetime,moneyNumber MONEY default 0,itemID int default 0,moneyContent nvarchar(100),userName nvarchar(16));

ALTER TABLE [TBL_USER] ADD question VARCHAR(50) DEFAULT ''
ALTER TABLE [TBL_USER] ADD answer VARCHAR(50) DEFAULT ''

create table TBL_CLASS(classNumber nvarchar(8) PRIMARY KEY,className nvarchar(50),classIntro ntext);

create table TBL_classFile(fileID int IDENTITY (1,1) CONSTRAINT PrimaryKey PRIMARY KEY,userName nvarchar(16),classNumber nvarchar(8),folderID int default 0,fileName nvarchar(50),realFileName nvarchar(50),fileSize int default 0,fileContentType nvarchar(30),fileExtension nvarchar(10),fileIntro ntext,fileAddTime smalldatetime,isLink nvarchar(1) default 'N');

create table TBL_classFileLink(fileID int PRIMARY KEY,fileLinkAddress nvarchar(255));

create table TBL_classFileLog(logID int IDENTITY (1,1) CONSTRAINT PrimaryKey PRIMARY KEY,userName nvarchar(16),classNumber nvarchar(8),fileName nvarchar(50),userAction nvarchar(10),logTime smalldatetime);

create table TBL_classFolder(folderID int IDENTITY (1,1) CONSTRAINT PrimaryKey PRIMARY KEY,folderName nvarchar(30),userName nvarchar(16),classNumber nvarchar(8),parentFolderID int default 0,folderCreateTime smalldatetime);