[EMAIL PROTECTED] wrote:

Need to know the similar one in MySQL. Do we have views or any other
system tables in MySQL 4.0.21 which OUTPUTS the constraints and indices
in a particular table?


- show indexes from DATABASE_NAME.TABLE_NAME

- or, show create table DATABASE_NAME.TABLE_NAME;

- ian

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to