getting default value of a column
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!