Subject Re: [firebird-support] Obtaining default value of a field
Author Martijn Tonies
> > > Any other places I can check for default values?
> >
> > rdb$default_source
> >
>
> Am I correct in assuming that this field is a blob or some sort?

Yes, it's a blob.

RDB$FIELDS.RDB$DEFAULT_SOURCE holds the domain
base default.

RDB$RELATION_FIELDS.RDB$DEFAULT_SOURCE holds
the column based default which can override the domain based
default.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com