Indexes & Primary Keys or System tables

[Anon]

hi
where the table indexes & primary keys & Constraintsd stored in MYSQL

actually i want to write the tool which is converts the data from MySql to SQL Server

so i required the information for the System Tables

thank u

Regards
KVV Prasad

[[deleted]]

You can't read the system tables directly.
Use mysqldump:

mysqldump -d database

that will give the database scructure in SQL format.