Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forumdisplay.php?f=42)
-   -   Default How to get Table schema information ? (http://www.go4expert.com/showthread.php?t=17959)

amit_27 12Jun2009 14:09
Default How to get Table schema information ?
 
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 4Sep2009 11:52
Re: Default How to get Table schema information ?
 
Code:
DESC <tablename>


All times are GMT +5.5. The time now is 17:23.