Determining the default value of a column

• toddhd

  SSC Veteran

  Points: 205

  More actions

  December 10, 2003 at 12:38 pm

  #84918

  I am using SQLDMO and ASP.NET to examine database tables. I would like to be able to determine if a particlar column has a default value, and perhaps, what that default value is.

  I already have a column object, how do I get the default value? For example, my dateadd field has a default value of getdate()

  Thanks

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  December 10, 2003 at 8:43 pm

  #485641

  EXEC sp_columns @table_name = 'TableName' ,@column_name ='ColumnName'

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  December 11, 2003 at 5:19 am

  #485683

  It's the Text property of the DMO column object's DRIDefault property.

  --Jonathan

  
  
  --Jonathan