get table information

[jayson_13]

hi,

I just wondering why i can't get the foreign key constraint if i describe a table. Anybody know how to get all the table information? Thanks! Anybody have free backup tools for mysql?

[Strike]

MySQL doesn't support foreign keys yet. So if you are using MySQL you can't have a foreign key constraint (unless you are using 4.0.x and I'm not even sure that has foreign key support). Also, there's no SQL standard for describing tables that I know of - DESCRIBE is a MySQL-ism. Just in case you care about portability.

[jayson_13]

FYI i am using MySQL 4.1.0 alpha. And it support foreign key constraint.

[Strike]

Okay, that does explain the foreign key bit. But I also can't seem to find the MySQL docs for 4.1 on their site, so I can't do much to help. The only thing I can suggest is that you dig through whatever documentation it came with.

[iDxMan]

Are you using innodb tables? Foreign keys might only be avail for inno.


backup? mysqldump ..


-r

[stuka]

From the command line client for MySQL, \dt tells you the table names in the current db, and \d TABLE_NAME tells you all about the table TABLE_NAME, including constraints.