如果你是access库那么可以这样 Sub RenameTable (conStr, oldName, newName) 'Create object and connect to DB... Dim objADOXDatabase Set objADOXDatabase = Server.CreateObject("ADOX.Catalog") objADOXDatabase.ActiveConnection = conStr 'Change the name... objADOXDatabase.Tables(oldName).Name = newName 'Clean up... Set objADOXDatabase = Nothing End Sub 注意jet 4.0才有这个功能 3。51不可以 如果是sql 就更简单了一句话,具体忘了可以查sql文档sp_XXXX
别忘了应用adox microsoft ado ext.2.5 for ddl and security ado主要用于数据库中的数据操作 adox主要针对数据库结构操作
正確答案來了,答對了一定要給分. dim cmd as adodb.command dim cn as adodb.connectionset cn=adodb.connection cn.cursorlocation=aduseclient cn.open connectstr set cmd=new adodb.command cmd.activeconnection=cn cmd.adcmdtype=adcmdtext cmd.adcmdtext="sp_rename '表名','新的表名'" cmd.execute 這樣就可以了.
Dim tbl As ADOX.table Dim cat As ADOX.CatalogSet cat = New ADOX.Catalog cat.ActiveConnection = conntempSet tbl = cat.Tables.item(oldname) tbl.name = newname
Dim tbl As ADOX.table Dim cat As ADOX.CatalogSet cat = New ADOX.Catalog cat.ActiveConnection = conntemp(什么意思?)Set tbl = cat.Tables.item(oldname) tbl.name = newname
运行SQL语句select into新表,运行SQL语句"drop table 旧表"删除旧表
SQLServer,可以用SQL_DMO对象
FROM source
DROP {TABLE table | INDEX index ON table}
Sub RenameTable (conStr, oldName, newName)
'Create object and connect to DB...
Dim objADOXDatabase
Set objADOXDatabase = Server.CreateObject("ADOX.Catalog")
objADOXDatabase.ActiveConnection = conStr 'Change the name...
objADOXDatabase.Tables(oldName).Name = newName 'Clean up...
Set objADOXDatabase = Nothing
End Sub
注意jet 4.0才有这个功能 3。51不可以
如果是sql 就更简单了一句话,具体忘了可以查sql文档sp_XXXX
microsoft ado ext.2.5 for ddl and security
ado主要用于数据库中的数据操作
adox主要针对数据库结构操作
下例将表 customers 重命名为 custs。EXEC sp_rename 'customers', 'custs'
dim cmd as adodb.command
dim cn as adodb.connectionset cn=adodb.connection
cn.cursorlocation=aduseclient
cn.open connectstr
set cmd=new adodb.command
cmd.activeconnection=cn
cmd.adcmdtype=adcmdtext
cmd.adcmdtext="sp_rename '表名','新的表名'"
cmd.execute
這樣就可以了.
Dim cat As ADOX.CatalogSet cat = New ADOX.Catalog
cat.ActiveConnection = conntempSet tbl = cat.Tables.item(oldname)
tbl.name = newname
Dim cat As ADOX.CatalogSet cat = New ADOX.Catalog
cat.ActiveConnection = conntemp(什么意思?)Set tbl = cat.Tables.item(oldname)
tbl.name = newname