How do retrieve Column Description ?

• calenkl

  SSC Enthusiast

  Points: 109

  More actions

  July 16, 2002 at 8:09 pm

  #157880

  Hi All !!

  i'm using MSSQL 2000 and have a question to ask...

  how can i retrieve the description of a column (field)?

  Notice that whenever we create a table using design view, there's a properties panel at the bottom of the window showing all the properties for the column ? The properties includes Description, Default Value, Identity & etc.

  Now, i need to retrieve these properties for my project... i've found a few query strings but no one return me the Description of the field...

  SELECT syscolumns.name AS ColumnName From syscolumns

  INNER JOIN sysobjects ON syscolumns.id = sysobjects.id

  Where sysobjects.Name =

  order by sysobjects.name

  SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS

  WHERE TABLE_NAME =

  EXEC sp_columns @table_name =

  so, any ideas ?? Thanx for viewing anyway !!

  🙂

• Sachin Dedhia

  SSCrazy

  Points: 2104

  More actions

  July 16, 2002 at 11:50 pm

  #432845

  You can find the description for a column in 'value' column of 'sysproperties' table.

  Hope this helps you...

  IF U DON'T SEEK PERFECTION, U CAN NEVER REACH EXCELLENCE!!!

  SD

  
  

  Regards,
  Sachin Dedhia

• calenkl

  SSC Enthusiast

  Points: 109

  More actions

  July 17, 2002 at 12:42 am

  #432846

  Thanx !!

  i've finally found it from the sysproperties...

  Thanx !!