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

Re: I have a issue with "Rename" command

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: I have a issue with "Rename" command
Date	Thu, 15 Dec 2011 08:23:53 -0500
Organization	A noiseless patient Spider
Lines	15
Message-ID	<jccsdo$pk8$1@dont-email.me> (permalink)
References	<36ee0d8a-803c-455e-ab58-5b1d1fcb6a17@k5g2000pra.googlegroups.com>
Injection-Date	Thu, 15 Dec 2011 13:24:08 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="NUmboHSNYG4cX5Ys9j8TNw"; logging-data="26248"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+0dj16jWqh59MfivijMV64bZwKbrRDarI="
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2800.2001
X-Newsreader	Microsoft Outlook Express 6.00.2800.2001
Cancel-Lock	sha1:zZb1XAsnHl2nprUM6JgQLsz4xHo=
X-Priority	3
X-MSMail-Priority	Normal
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:872

Show key headers only | 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