How to get a db table metadata

tariqahsan has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: How to get a db table metadata by cmeyer (Pilgrim) on Jun 09, 2005 at 17:01 UTC
Take a look at the `$dbh->column_info()` method of DBI. -Colin. WHITEPAGES.COM \| INC	[reply] [d/l]
Re^2: How to get a db table metadata by tariqahsan (Beadle) on Jun 09, 2005 at 17:54 UTC
Got it done by using $dbh->table_info("", $schema, $table_name, "TABLE"); Thank you all!	[reply]
Re^2: How to get a db table metadata by davidrw (Prior) on Jun 09, 2005 at 17:11 UTC
also be sure too look at methods specific to DBD::Oracle	[reply]
Re: How to get a db table metadata by erix (Prior) on Jun 09, 2005 at 16:54 UTC
`select * from cols where table_name = 'YOURTABLE'` [download]	[reply] [d/l]
Re: How to get a db table metadata by mifflin (Curate) on Jun 09, 2005 at 17:01 UTC
You can use the following view... SQL>desc all_tab_columns Name Null? Type ------------------------------- -------- ---- OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) COLUMN_NAME NOT NULL VARCHAR2(30) DATA_TYPE VARCHAR2(9) DATA_LENGTH NOT NULL NUMBER DATA_PRECISION NUMBER DATA_SCALE NUMBER NULLABLE VARCHAR2(1) COLUMN_ID NOT NULL NUMBER DEFAULT_LENGTH NUMBER DATA_DEFAULT LONG NUM_DISTINCT NUMBER LOW_VALUE RAW(32) HIGH_VALUE RAW(32) DENSITY NUMBER NUM_NULLS NUMBER NUM_BUCKETS NUMBER LAST_ANALYZED DATE SAMPLE_SIZE NUMBER [download] Other views would be user_tab_columns and dba_tab_columns (if you have the privs) DBI does have some methods (but the perldocs say they are experimental) to extract meta data (at least on the version I'm using it says it's experimental).	[reply] [d/l]
Re^2: How to get a db table metadata by dbwiz (Curate) on Jun 09, 2005 at 19:14 UTC
Please have a look at 'Describe table' doesn't work (Oracle/dbiproxy) (especially perrin's answer).	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.


go ahead... be a heretic
	PerlMonks