Click here to Skip to main content
Click here to Skip to main content

How to rename the column on a DB

, 9 May 2010
Rate this:
Please Sign up or sign in to vote.
That isn't complicated task but i thought this trick is enough usefullSP_RENAME 'YourTable.OldColumnName','NewColumnName','COLUMN'
That isn't complicated task but i thought this trick is enough usefull
 
SP_RENAME 'YourTable.OldColumnName','NewColumnName','COLUMN'

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Pavel Yermalovich
Software Developer (Senior)
Belarus Belarus
Software developer with over 3 years of extensive experience in analysis, design and development. Recently, most interested in refactoring and design patterns applied to .NET Framework.
 
Core technologies I am using: OOP, OOD, DDD, TDD, N-tier applications, enterprise development.
 
Certificates:
Brainbench: .NET Framework 3.5 Fundamentals, Data Modeling Concepts, Web Design Concepts, C#
 
Microsoft: Exam 70-526: TS: Microsoft .NET Framework 2.0 - Windows-Based Client Development
 
INTUIT.RU: Development of Web-application ASP. NET Using Visual Studio. NET, Web applications in ASP.NET, Microsoft .NET Framework Distributed Applications Development.
 
Specialties
NET Framework : 2.0, 3.5, 4.0
Languages and technologies: C#, ASP.NET MVC 2, ASP.NET MVC 3, WCF, ASP.NET 4.0, Web Services, ADO.NET, LINQ, Entity Framework, NHibernate 3.0, JavaScript, HTML, CSS, XML, Ajax
RDBMS : SQL Server 2005, 2008, 2008 R2, MS Access.
Reporting: MS SQL Reporting Services, Crystal Reports

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 9 May 2010
Article Copyright 2010 by Pavel Yermalovich
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid