Default How to get Table schema information ?

amit_27's Avatar, Join Date: May 2009
Go4Expert Member
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
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Code:
DESC <tablename>