title: sql server : get default value of a column
body: <p>I execute a select to get the structure of a table.
  I want to get info about the columns like its name or if it's null or if it's primary key..
  I do something like this</p>
  
  <pre><code>....sys.columns c...
  c.precision,
  c.scale,
  c.is_nullable as isnullable,
  c.default_object_id as columndefault,
  c.is_computed as iscomputed,
  </code></pre>
  
  <p>but for default value i get the id..something like 454545454 but i want to get the value "xxxx". What is the table to search or what is the function to convert that id to the value.
  Thanks</p>