Loading ...

How To Rename ColumnName in SQL

Who is online?  0 guests and 0 members
home  »  blogs  »  Vijendra Shakya  »  How To Rename ColumnName in SQL

How To Rename ColumnName in SQL

(0)
(2586)
0
/5
Avg: 0/5: (0 votes)

posted 7/2/2009  by Vijendra Shakya

Many times there is needed to change the column name of table.
So, we can change the column name of the table as follow:

Sp_Rename 'TableName.OldColumnName','NewColumnName','Column'

Here Column is the keyword.

Hope it will help to all…

 tags: ColumnName, Rename, Sp_Rename, SQl

Product Spotlight

ASP.NET Hosting Spotlight
 

Comments (no comments yet)

Add a new comment
  • Name:*
  • Email:*
  • Website:
Type the characters you see in the image *

Confirm

Latest community blog posts

  • Announce training of asp.net from 16 Jan,2012 for MCA and Btech students
    29 days ago by websoftCreation Websoftcreation
    Hi, Websoftcreation started new batch of asp.net and PHP for MCA,M.Sc,B.tech from 16 Jan,2012 at Jaipur centre. You can take part in this training by just post request on websoftcreation.co.in website. Regards Websoftcreation,Jaipur
  • My Last Post
    14 days ago by Vincent Maverick Durano
    Well this is really not my last post but I will not be blogging anymore here to avoid cross posting of contents. Instead you can visit my official blog at: Vinz' Blog Note: Stop blogging here doesn't mean I will stop contributing to the codeasp community, of course I will still be moderating posts a...
  • Application Pool Failure: Rapid Fail Protection
    12/15/2011 by Vivek Thakur
    We were stuck with a weird issue. Our ASP.NET web app was crashing for some reason and the event log only displayed Stackoverflow exception. We want to narrow down the reason for the crash and since stackoverflow exceptions are easy to debug (even crash dumps didnt give help much), we wanted our app...
  • Sql Server Timeout expired. The timeout period elapsed prior to completion of the operation
    12/9/2011 by Vivek Thakur
    The default SqlCommand timeout is 30 seconds, so you might get this error while executing a lengthy Sql operation (like creating a DB and its schema via C# code): Error : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. In order to fix...
  • Microsoft.SqlServer.SMO and Microsoft.SqlServer.Management assemblies issue
    12/2/2011 by Vivek Thakur
    We had created a Visual Studio project in C# to create SQL Server 2005 database via C# code. We were referencing these assemblies: Microsoft.SqlServer.Management.Sdk.Sfc.dll Microsoft.SqlServer.Smo.dll Microsoft.SqlServer.ConnectionInfo.dll We also added this DLL but did not reference it as we reali...

Vijendra Shakya's latest blog posts

Product Spotlight

ASP.NET Hosting Spotlight

 

Quick Vote

What kind of email newsletter would you prefer to receive from CodeAsp.Net?