RENAME TABLE Command Example See AlsoRenames a table in the current database.SyntaxRENAME TABLE TableName1 TO TableName2ArgumentsTableName1Specifies the name of the table to be renamed.TableName2Specifies the new name of the table.ResYou cannot use RENAME TABLE to change the name of a free table; use RENAME instead.
1.引用adox,如同引用ado一样,在工程-引用,添加 microsoft ado ext 2.1 for ddl and securit.. 2. dim myct as adox.catalog set myct = new adox.catalog dim strnewtablename as string myct.tables("oldtablename").name=strnewtablename注:因为我现在在学vb.net,vb6.0 已经删除,所以不知是否正确,大体上是这样,自己试试
Example See AlsoRenames a table in the current database.SyntaxRENAME TABLE TableName1 TO TableName2ArgumentsTableName1Specifies the name of the table to be renamed.TableName2Specifies the new name of the table.ResYou cannot use RENAME TABLE to change the name of a free table; use RENAME instead.
2.
dim myct as adox.catalog
set myct = new adox.catalog
dim strnewtablename as string
myct.tables("oldtablename").name=strnewtablename注:因为我现在在学vb.net,vb6.0 已经删除,所以不知是否正确,大体上是这样,自己试试