Default How to get Table schema information ?

Go4Expert Member
12Jun2009,14:09   #1
amit_27's Avatar
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
Team Leader
4Sep2009,11:52   #2
pradeep's Avatar
Code:
DESC <tablename>