Insert the following into a job and schedule it to run whenever you need it
or you can run it in query analyzer.


exec sp_rename 'oldtablename','newtablename'
Hope this helps,
E

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Wednesday, August 28, 2002 2:02 PM
To: LazyDBA.com Discussion
Subject: script to rename tables



Guys, I need to set up a job to delete or rename a table once weekly.
Is this going to be an easy process or something I have to spend days
writing,

thanks,



---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page