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!

Never heard of the script.

If you don't provide a URL to it or the code for it, it's hard for us to guess at what it is doing and/or why it doesn't get the default.

Also, what database are you using??? You seem to be implying that you are using SyBase?