>>Does anybody know how can I retrieve a "default" value from a field using t-sql?
>Sorry I forgot the word "default"
>>Thanks in advance.
Check information_schema.columns:
Select column_name, column_default
From information_schema.columns
Where table_name="mytable"
You can find about other column settings if you select * instead. HTH