Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #874

Re: I have a issue with "Rename" command

Show all headers | View raw

On Dec 15, 6:23 pm, "Bob Barrows" <reb01...@NOyahooSPAM.com> wrote:
> chaitra jagirdar wrote:
> > i have a table customers with columns :name,age,contact_no
>
> > 1. i want to rename the table cutomers to nokia_customers
> > 2.i want to rename the column name to customer_name
>
> > i know i have to use rename command but is alter command necessarily
> > be used before using rename command.
>
> I hope you're not planning to have separate tables for each of your
> customers ...

Hello There,

Please use sp_rename with caution as stated by MS itself
--Caution: Changing any part of an object name could break scripts and
stored procedures.

As you are changing table name you have to look for views/proc/
functions/triggers etc and modify wherever the existing table name was
referenced.

Not a recommended practice, I hope this would be beginning stage of
project. In that case no major problem.
but if project is kicked off then u need to be careful.

Hope it helps

With Warm regards
Jatinder Singh
http://jatindersingh.blogspot.com

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

I have a issue with "Rename" command chaitra jagirdar <chaitra.jagirdar7@gmail.com> - 2011-12-14 21:38 -0800
  Re: I have a issue with "Rename" command Erland Sommarskog <esquel@sommarskog.se> - 2011-12-15 09:16 +0000
  Re: I have a issue with "Rename" command "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-12-15 08:23 -0500
    Re: I have a issue with "Rename" command jsfromynr <jatinder.1975@gmail.com> - 2011-12-21 04:47 -0800

csiph-web