[dba-SQLServer] Alter column

JWColby jwcolby at colbyconsulting.com
Wed Jan 31 08:23:44 CST 2007


Bueno.  So SQL per se does not but a SP can.

Done!

Thanks.


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, January 31, 2007 8:51 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Alter column

EXEC sp_rename 'MyTable.OldColumnName', 'NewColumnName', 'COLUMN' 
 
for reference
 
http://doc.ddart.net/mssql/sql70/sp_ra-rz_11.htm
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: dba-sqlserver-bounces at databaseadvisors.com on behalf of JWColby
Sent: Wed 31/01/2007 13:44
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Alter column



Can the alter column SQL syntax change a column name?

John W. Colby
Colby Consulting
www.ColbyConsulting.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 







More information about the dba-SQLServer mailing list