Edit column names in sql2008

Discussion in 'Databases' started by PompeyHuss, Jul 6, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. PompeyHuss

    PompeyHuss

    Hi. I have used different versions of sql with the mylittleadmin tool and been able to change a column name after it has been created. I do not seem to be able to do this with sql 2008. Am I just being dense, or is it not possible?:confused:
     
    PompeyHuss, Jul 6, 2009
    #1
  2. Joseph Jun

    Joseph Jun DiscountASP.NET Staff

    If you click on one of your user-defined tables, you should get a menu that displays on your screen and the first item should be "Details" and you should then see general properties of your table.

    The first item that will be displayed is columns which you'll want to click on and then you can hit the column name that should allow you to rename it. Please see the attached file for a screen capture.

    In the event that you still have problems with the utility, can you let us know what steps you're taking so that we can help you out?
     

    Attached Files:

    • mla.jpg
      mla.jpg
      File size:
      12.3 KB
      Views:
      389
    Joseph Jun, Jul 6, 2009
    #2
  3. PompeyHuss

    PompeyHuss

    Thanks. So simple when you know how!:)
     
    PompeyHuss, Jul 7, 2009
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page