With SQL database and using ADO, is there anyway to access in VB, the default values of particular fields in the database?

The field object of a recordset doesn't seem to have a 'defaultvalue' property and ADOX seems to have the same limitation.

Any ideas attall would be appreciated?

Simon.