Hi,
Thank you. But I want select the constraints and indices used on the
table. How can we get this information?. Please help me in this.
Ian gave you the answer:
From: Ian Sales[...]
- show indexes from DATABASE_NAME.TABLE_NAME
The syntax is: SHOW INDEX FROM tablename FROM dbname
- or, show create table DATABASE_NAME.TABLE_NAME;
To elaborate: You can not use the SELECT statement to get this information in MySQL, like you can in Oracle. In MySQL, you can only get this information from other statements, like SHOW INDEX FROM ... and SHOW CREATE TABLE.
<URL: http://dev.mysql.com/doc/mysql/en/SHOW_INDEX.html > <URL: http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html >
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
