View Single Post
  #1 (permalink)  
Old June 18th, 2008, 03:58 AM
elygp elygp is offline
Authorized User
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default getting default value of a column

Hi All,

I have a script which extracts table from a database. I don't know if you're familiar with it, it was written by Ed Barlow. The script works fine, it can get the structure of a table from a datasource just like sp_help except for one error. The script cannot get the DEFAULT value of a column. Does anyone has tried using this script? Or is there a stored procedure I can use to get the default value of a column of a table. sp_help in Sybase also does not get the DEFAULT value of a column. Thanks!

Reply With Quote