1.如何用SQL语句在ACCESS数据库里创建一个新的表?
2.如何删除这个表?谢谢!

解决方案 »

  1.   

    CREATE TABLE `base_Info` (                                                                                                                                                                                     
                  `ID` int(11) NOT NULL auto_increment,                                                                                                                                                                         
                  `Type` varchar(10) default NULL,                                                                                                                                                                              
                  `Code` varchar(50) default NULL,                                                                                                                                                                              
                  `Name` varchar(50) default NULL,                                                                                                                                                                              
                  PRIMARY KEY  (`ID`)                                                                                                                                                                                           
                ) ;
    华东信息科技 Roping.Zong