sql语句 建立access数据表

在sql中,   我用下边的语句就可以建立数据库,我现在想用这些语句,在access中建一个这样的数据表,就是这个意思!  
   
  CREATE   TABLE   FirewallLog   (  
  [ClientIP] varchar(32),  
  [ClientUserName] varchar(32),  
  [ClientAgent] varchar(128),  
  [ClientAuthenticate] varchar(5),  
  [logDate] datetime,  
  [logTime] datetime,  
  [service] varchar(12),  
  [servername] nvarchar(32),  
  [referredserver] varchar(32),  
  [DestHost] varchar(255),  
  [DestHostIP] varchar(32),  
  [DestHostPort] int,  
  [processingtime] int,  
  [bytessent] float,  
  [bytesrecvd] float,  
  [protocol] varchar(8),  
  [transport] varchar(8),  
  [operation] varchar(8),  
  [uri] varchar(255),  
  [mimetype] varchar(32),  
  [objectsource] varchar(12),  
  [resultcode] int,  
  [CacheInfo] int,  
  [rule#1] nvarchar(128),  
  [rule#2] nvarchar(128),  
  [sessionid] int,  
  [connectionid] int  
  )  
   
  CREATE     INDEX   [IX_FirewallLog_Date]   ON   [FirewallLog]([logDate])   ON   [PRIMARY]  
  GO  
   
    CREATE     INDEX   [IX_FirewallLog_DateTime]   ON   [FirewallLog]([logDate],   [logTime])   ON   [PRIMARY]  
  GO
posted @ 2008-08-07 12:06  Wind·e  阅读(1350)  评论(2)    收藏  举报