Renaming table in Access database using SQL 1

[andybeh]

Hi All,

Can someone help me with finding a way to rename a table in an Access 2000 database using SQL commands in asp please?

Either the solution or a pointer to the right resource would be great.

Cheers

ab

 

[GaryC123]

Use FSO

<%
Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot
Set fileObject = fso.GetFile(Server.MapPath(&quot;oldname.mdb&quot)

response.write fileObject.Name & &quot;<br>&quot;
fileObject.Name = &quot;newname.mdb&quot;
response.write fileObject.Name
Set fileObject = Nothing
Set fso = Nothing

%>

http://www.intouchmedialtd.com

 

[PatrickIRL]

A quick hack is to do this ...

&quot;SELECT * INTO <new table> FROM <old table>&quot;

this will create an identical copy of the old table. Then use this ...

&quot;DROP TABLE <old table>&quot;

... and you have what you want.

I'm sure there's a better way to do this. If you were using SQL Server you could use sp_rename, not sure if Access does the stored procedure thing though.

Regards,

Patrick

 

[GaryC123]

Oops, should've read the question more carefully - table not database

http://www.intouchmedialtd.com

 

[onpnt]

RENAME TABLE OLDNAME TO NEWNAME


_____________________________________________________________________

_{Hakuna matata!!}