home » blogs » Vijjendra » How To Rename ColumnName in SQL

How To Rename ColumnName in SQL

change text size: A A A

posted 7/2/2009 by Vijjendra

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
To rate this blog entry please  register or login

Author

Vijjendra Vijjendra (Member since: 11/29/2008)
This is Vijendra Singh Shakya.

View Vijjendra 's profile

Comments (no comments yet)

Post a comment

Name:
 *  

Email: (your email is kept secure)
 *  

Website:



example: "http://codeasp.net"

Comment (No HTML)  

Type the characters:
 *
 
   

Join CodeAsp.Net for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

Blogs RSS Feed

Vijjendra's latest blog posts

  • Find Maximum value from an Enum
    11/29/2009
    Here I have discussed find the maximum value from enum.    Suppose we have an enum like: public enum TestEnum     {         A=1,         X=2,         E=3,         R=4,         O=5     }     if our enum have values like above(Incremented by one),then we can Find the Max enum values like as follows:   String strMaxEnumValue = Enum .GetValues(typeof (TestEnum )).Cast<TestEnum >().Last().ToString();     It returns last element of the sequence.     It gives you...
  • What is Paged DataSource?
    11/12/2009
    PagedDataSource is a class which encapsulates the paging related properties which is required to perform paging in data bound control like Repeater/DataList. PagedDataSource class comes under System.Web.UI.WebControls namespace. PagedDataSource contains following common properties: PageSize: It Defines number of records shown on the page. it’s default value is 10. AllowPaging: Indicating whether paging is enabled for data bound control or not. Its default value is “false”. Current...
  • Find Date after a given week(s) or month(s)
    11/4/2009
    Here I am discussing to find date after a given week or months.For example I want to find the date after 1 week or 2 months from today.Find date after 2 week or 2 months then we can achieved this as like: DateTime dateTime = DateTime.Now.AddDays(14); //we can also do this as DateTime.Now.AddDays(2*7) DateTime dateTime1 = DateTime.Now.AddMonths(2); The output will be: 11/18/2009 3:59:43 PM 1/4/2010 3:59:43 PM If we want only date part then we can achieved this as like: string dt ...
  • Find Enum Name from Value
    10/30/2009
    Here I have discuses find name of Enum from Enum value. I have a Enum like: public enum EnumName { Vijendra=1, Singh=2, Shakya=3 } I have the value of this Enum in my database table, when I fetch that value from database then we want to show this value as Enum name. For example in my database there is 2 when I retrieve it from database then I want to show it “Singh” instead of 2.I have done this as follows: int enumValue = 2//suppose this value is retrieve from da...
  • Auto refresh page
    10/6/2009
    Here I have discussed how we auto refresh page and why we need to auto refresh the page.Page is Auto refresh means forcing a page to post back without user input. Following are the main reason to auto refresh the page.1. Redirecting to a new URL after some specific time. 2. Refreshing page information within a given time period.3. Maintain a session state. We auto refresh the page in following way: <meta http-equiv="refresh" content="30;url=http://www.codeasp.net/"> Put th...
Blogs RSS Feed

Latest community blog posts

  • Fetching Data from Database and Populating fields in the Form using LINQ to SQL
    3/11/2010
    In my previous example I have demonstrated how to create a simple form that would allow users to insert data to the database using L2S. In this example I’m going to demonstrate how to fetch and filter data from database and fill the fields in the form using L2S.  This example is basically a continuation of my previous example here . So I would suggest you to take a look at my previous example first before you proceed reading this example. Continue...
  • Inserting Data to Database using LINQ to SQL
    3/11/2010
    Few months ago, I’ve created a simple demo about “Creating a Simple Registration Form using the ADO.NET way ”. In this article, I'm going to demonstrate how to create a simple form that would allows users to insert data to the database using L2S.   As an overview, LINQ to SQL is a technology that allow you to query sql server. LINQ to SQL is an O/RM (object relational mapping) implementation that ships in the .NET Framework "Orcas" release, and which allows you to model a relatio...
  • Learning ASP.NET: Where to Begin?
    3/1/2010
    I often see questions at forums(http://forums.asp.net ) asking stuffs like: Where to begin? Where Do I start? How to Get Started? So I deciced to write this "boring " post to express my opinion and hopefully this can help beginners find their way to get started with ASP.NET. Based on my experience learning ASP.NET is just like learning how to play a guitar.. (oh really? why could I say that? ).(1) First you must have this what we called "interest " because if you d...
  • Pluralsight On-Demand Training library
    3/1/2010
    Pluralsight is an online .NET Training library which provides online training materials for .NET developers. Example trainings available on demand: ·  .NET 3.5 ·  Agile Team Practices ·  ASP.NET 3.5 ·  ASP.NET AJAX ·  ASP.NET MVC ·  BizTalk 2006 ·  BizTalk Server 2006 R2    ·  BizTalk Server 2009 ·  iPhone ASP.NET ·  LINQ ·  Managed Services Engine ·  Silverlight 3 ·  SharePoint Services ·  SQL Server 2008    ·  VSTS ·  WCF ·  Windows Server AppFabric, formerly "Dubli...
  • NEW DATA TYPES IN SQL SERVER 2008
    2/17/2010
    • Date and Time: Four new date and time data types have been added, making working with time much easier than it ever has in the past. They include: DATE, TIME, DATETIME2, and DATETIMEOFFSET. • Spatial: Two new spatial data types have been added--GEOMETRY and GEOGRAPHY-- which you can use to natively store  and manipulate location-based information, such as Global Positioning System (GPS) data. • HIERARCHYID: The HIERARCHYID data type is used to enable database applications to m...