Post reply

How Can i add the Description to a field

  • December 28, 2001 at 12:29 am

    #78094

    I am using SQL 2000 and i create a Table

    The Table Structure like this

    Company

    (ID int,

    Name Varchar(16)

    )

    I want to add the Descrition of the 2 feilds

    for ID .. i want to add 'Company ID'

    for Name .. 'Company Name'

    NOTE: I don't want to add using Enterprise Manager, i want to add using Query Analyzer

    How can i add this

    Thanks for your help.

    Madhavi

  • December 28, 2001 at 6:16 am

    #421454

    Take a look at 'Alter Table' in Books Online. Adding a column is pretty straight forward. Sounds like you're new to SQL, so you might want to keep this idea in mind for later on - anytime you can't figure out how to do something in QA that you CAN do in Enterprise Manager, run a Profiler session while you do the task in EM - that way you can see exactly what is being sent over.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • December 28, 2001 at 10:06 am

    #421465

    You can also make the change in em, then click the script button. It will allow you to save a script of your changes and you can examine this.

    Steve Jones

    steve@dkranch.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply