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

Re: I have a issue with "Rename" command

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: I have a issue with "Rename" command
Date	2011-12-15 08:23 -0500
Organization	A noiseless patient Spider
Message-ID	<jccsdo$pk8$1@dont-email.me> (permalink)
References	<36ee0d8a-803c-455e-ab58-5b1d1fcb6a17@k5g2000pra.googlegroups.com>

Show all headers | View raw

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 ...

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next 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