Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   Default How to get Table schema information ? (http://www.go4expert.com/forums/default-table-schema-information-t17959/)

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 10:05.