sql - rename table and also delete table

[leonepaolo]

Hi,

I'm trying to use SQL to rename a table - here's what I've done so far and it's not working.

db.Execute "SELECT * RENAME " & strTableToRename & " TO " & strNewTableName

I'd also like to know how to delete a table.

Thank you,
Paolo

 

[MatthewPeters]

To rename:
EXEC sp_rename 'customers', 'custs'

to Delete:
drop tableName