How Can i add the Description to a field

• Madhavi1973

  Newbie

  Points: 1

  More actions

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  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
  Connect with me on LinkedIn

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  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