MySQL Forums
Forum List  »  Newbie

Re: creating data dictionary
Posted by: Peter Brawley
Date: February 19, 2010 10:36AM

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

Options: ReplyQuote


Subject
Written By
Posted
February 16, 2010 05:47AM
February 19, 2010 09:41AM
Re: creating data dictionary
February 19, 2010 10:36AM


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.