Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Posts
    8

    Unanswered: Schemas Comparision

    Hi All,

    In oracle we can get the columns related information for a particular shcema by quering from user_tab_columns. As a administrator I can write a script file which gives the result of the differences if there are any in a given two schemas.

    Is there any way to get the column information other than " SHOW FIELDS FROM tablename" ???

    Regards,
    Sekhar

  2. #2
    Join Date
    Sep 2002
    Posts
    2
    Hi Sekhar,
    Did you ever find out how to do this, I've been looking for ages.

    Steve

  3. #3
    Join Date
    Jul 2002
    Posts
    8

    Lightbulb Not like Oracle but...

    http://www.mysql.com/doc/en/SHOW.html

    SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]

    SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]

    Closest that I found...

    Kam

  4. #4
    Join Date
    Sep 2002
    Posts
    2
    Yes but the problem everyone seems to be having is how to do a select on these details.

    i.e Select * from (Show Tables) where tablename = 'z'

    And then possible do a join on the details for the columns of that table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •