Martin Reid
mwp.reid at qub.ac.uk
Wed Jan 31 07:51:07 CST 2007
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/>