Re: creating data dictionary
Dinesh,
For database `db`, try ...
SELECT
LOWER(table_name) AS 'Table',
LOWER(column_name) AS 'Column',
ordinal_position As 'Ordinal Position',
IF(column_default='',' ',column_default) AS 'Default',
UPPER(data_type) AS 'Type',
character_maximum_length AS 'Max Len',
character_octet_length AS 'Octet Len',
numeric_precision AS 'Precision',
numeric_scale AS 'Numeric Scale',
is_nullable AS 'Null',
character_set_name AS 'Character Set',
collation_name AS 'Collation'
FROM information_schema.columns
WHERE table_schema = 'db'
ORDER BY table_name,'Ordinal Position';
PB
http://www.artfulsoftware.com
Subject
Written By
Posted
February 16, 2010 05:47AM
February 19, 2010 09:41AM
Re: creating data dictionary
February 19, 2010 10:36AM
February 24, 2010 07:02AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.