1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Default How to get Table schema information ?

Discussion in 'MySQL' started by amit_27, Jun 12, 2009.

  1. amit_27

    amit_27 New Member

    Joined:
    May 19, 2009
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    0
    How can we get the table schema information in MYSQL 5.1.34?

    Like we use in ORACLE to get it as:

    OCIDescribeAny() // //get the describe handle for the table to be described.

    OCIAttrGet() // to get parameter handle

    OCIAttrGet() ////get the number of columns in the table
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Code:
    DESC <tablename>
     

Share This Page