[dba-SQLServer]Changing a Column Name Globally

Adam Cogan www.ssw.com.au AdamCogan at ssw.com.au
Wed Nov 5 18:04:31 CST 2003


Arthur

 

Not sure if you want to use a 3rd Party utility, but we have used Speed
Ferret - a Find and Replace thing many times. It is from a company
called Moshannon - more info at 

 
<http://www.ssw.com.au/SSW/Standards/DeveloperGeneral/TheBest3rdPartyToo
ls2.aspx#SpeedFerret>
http://www.ssw.com.au/SSW/Standards/DeveloperGeneral/TheBest3rdPartyTool
s2.aspx#SpeedFerret

 

Adam

 <http://www.ssw.com.au/> www.ssw.com.au 

 

 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Monday, 6 October 2003 1:14 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer]Changing a Column Name Globally

 

Suppose I want to change a column name globally (i.e. in every table,

every sproc, every view and every UDF). Is there a concise way of doing

it? SalesID -> SaleNumber.

 

TIA,

Arthur

 

-----Original Message-----

From: dba-sqlserver-bounces at databaseadvisors.com

[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart

McLachlan

Sent: Sunday, October 05, 2003 3:43 PM

To: dba-sqlserver at databaseadvisors.com

Subject: Re: [dba-SQLServer]Question about Computed Columns

 

 

On 5 Oct 2003 at 15:25, Stephen Hait wrote:

 

> Computed columns, maybe?

> 

> > When what was introduced to SQL

> > 

 

That's the trouble with relying on  the subject to contain part of 

your message.  

 

I (plus, I suspect, many others - including Paul) just flick through 

their list messages without even looking at the Subject header.

 

It's actually quite annoying to have to look up at the subject to get 

the sense of the message when you are skipping through them.

 

Could I ask nicely that people put all the relevant content in the 

body? Please?

 

 

 

 

 

-- 

Lexacorp Ltd

http://www.lexacorp.com.pg

Information Technology Consultancy, Software Development,System 

Support.

 

 

 

_______________________________________________

dba-SQLServer mailing list

dba-SQLServer at databaseadvisors.com

http://databaseadvisors.com/mailman/listinfo/dba-sqlserver

http://www.databaseadvisors.com

 

 

---

Incoming mail is certified Virus Free.

Checked by AVG anti-virus system (http://www.grisoft.com).

Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003

 

 

---

Outgoing mail is certified Virus Free.

Checked by AVG anti-virus system (http://www.grisoft.com).

Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003

 

 

 

_______________________________________________

dba-SQLServer mailing list

dba-SQLServer at databaseadvisors.com

http://databaseadvisors.com/mailman/listinfo/dba-sqlserver

http://www.databaseadvisors.com

 



More information about the dba-SQLServer mailing list