Re: [CDBI] How to retrieve meta information from database: not null, default, ...?

[prev] [thread] [next] [Date index for 2005/09/12]

>>>>> "Alex" == Alex Aminoff <alex@xxxxxxxxx.xxx> writes:

Alex> Is there some sort of plugin that does this?

Call $dbh->column_info("","",$table,$column)->fetchall_arrayref({})
and dump the resulting data structure.  Perhaps the IS_NULLABLE and
COLUMN_DEF info will give you what you want.

        -- 
        Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi